From: John Kanagaraj <>
Date: Thu, 20 Aug 2009 02:44:36 -0700
Message-ID: <>


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
> with

John Kanagaraj <>< (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 **

Received on Thu Aug 20 2009 - 04:44:36 CDT

Original text of this message