RE: Run stats on the basis of data increase

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • To: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • Date: Wed, 3 Jun 2009 16:45:01 -0400

Thanks for the tip, Greg!

-----Original Message-----
From: Greg Rahn [mailto:greg@xxxxxxxxxxxxxxxxxx] 
Sent: Wednesday, June 03, 2009 4:44 PM
To: Bobak, Mark
Cc: niall.litchfield@xxxxxxxxx; SMurphy@xxxxxxxxxxxxxxxxx; kennaim@xxxxxxxxx; 
saad4u@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Run stats on the basis of data increase

You dont need to disable and create a custom call, just  change the
default with DBMS_STATS.SET_PARAM:

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'.

Greg Rahn


Other related posts: