Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent Tuning Question....
Try running the query with literals (especially for v_journal_code).
You may have run the query with a value that represents enough rows
where the optimizer is using a plan that was good for that value, but
not all the others.
Also, is pga_aggregate_target set? The optimizer may determine it has enough memory to create the hash table rather than using nested loops.
Regards,
Steve Received on Wed May 10 2006 - 12:20:57 CDT