1. Any recent change (init.ora parameter, new/droped/altered index, table
    structure, partition or DATABASE UPGRADE or PATCH etc)?
  2. Run AWR report for that period and share it. If you do not have that licence
    then trace that report and trca (trace analyzer) it.
  3. How old is statistic (any change in collecting them)?

After this we can discuss …Toad has nothing with changing execution plans and
this is your problem.

Is there a question in there somewhere?

On Fri, 2009-11-20 at 09:03 -0800, Jeff Smith wrote:

Is there a question in there somewhere?

I think he was responding to the toad vs sql optimizer thread. Or else
that was intended to be a private email and not supposed to go to the