please show the explain plan.


are there any indexes on WORKSESSIONS?
have you tried with the /*+ append */ hint?