Re: GATHER_STATS_JOB
From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Thu, 20 Aug 2009 02:44:36 -0700
Message-ID: <2ead3a60908200244p772efc49j7ae65cbf7528879c_at_mail.gmail.com>
Gene,
Date: Thu, 20 Aug 2009 02:44:36 -0700
Message-ID: <2ead3a60908200244p772efc49j7ae65cbf7528879c_at_mail.gmail.com>
Gene,
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 <><
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 **
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 20 2009 - 04:44:36 CDT