RE: Run stats on the basis of data increase

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


Other related posts: