> away (3 hr query vs. 3 second!). Unfortunately, one DBA pointed out
> that the scheduled "gather_stats_job" job puts stats back on them every
> night.
Here we come again with this naming confusion... gather_stats_job
should have been called "mess_my_apps_while_nobody_looking". If they
named it correctly, every DBA would have delete it right away.
Perhaps, I need to log a documentation bug - installation/uprage guide
is missing the step to drop this job. ;-)
--
Best regards,
Alex Gorbachev
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jun 24 2006 - 15:57:32 CDT
