thank you very much for the reply.
i added 'parallel' hint on the SELECT query and I see that the timing
has reduced by 40% and the cost has reduced by half.
but the worrying thing is the 2 sorts in the disk. i was wondering how
this can be eliminated? if i am right, this might happen due to the
lack of sufficient memory. if i had set workarea-size_policy to AUTO
and pga_aggregate-size to 2GB, then oracle allocates only 5% of the
2GB, that is 100MB to the session for sorting. is there any way of
improving this by reconfiguring?
Received on Tue Jul 11 2006 - 07:12:02 CDT
