Re: Run stats on the basis of data increase

From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
To: Mark.Bobak@xxxxxxxxxxxx
Date: Wed, 3 Jun 2009 13:43:51 -0700

You dont need to disable and create a custom call, just  change the
default with DBMS_STATS.SET_PARAM:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm#i1048566

On Wed, Jun 3, 2009 at 1:14 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote:
> Beware that the default stats collection job likes to use method_opt=>’for
> all columns size auto’, which lets Oracle decide which columns get
> histograms.  In many circumstances, this is less than optimal.  There’s
> something to be said for disabling the default stats job and creating your
> own that does method_opt=>’for all columns size 1’.

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Run stats on the basis of data increase
From: Bobak, Mark

References:
- Run stats on the basis of data increase
  - From: Saad Khan
- RE: Run stats on the basis of data increase
  - From: Kenneth Naim
- RE: Run stats on the basis of data increase
  - From: Stephen T Murphy
- Re: Run stats on the basis of data increase
  - From: Niall Litchfield
- RE: Run stats on the basis of data increase
  - From: Bobak, Mark

Re: Run stats on the basis of data increase

Other related posts: