Date: Thu, 20 Aug 2009 02:44:36 -0700
A larger problem with the default GATHER_STATS_JOB is that it creates Histograms by default on columns that it thinks are skewed. This can cause all sorts of issues. Further, the default for various options changed in 10g (including the out-of-box capability to collect stats). This causes enough headaches if you are not aware that it does this!
> We have a GATHER_STATS_JOB running daily at 3AM and analyzing tables
John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **