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:
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
