Re: stats document links.

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 23 Mar 2011 16:57:07 +0000
Message-ID: <AANLkTinN2_x2CYY_wvhhL1jeVd1HraWFyR=YHkQER4m9_at_mail.gmail.com>

Well, will you stop implementing good ideas please. It reduces my scope for ranting. :)

Thanks for the heads up.

On Wed, Mar 23, 2011 at 4:45 PM, Greg Rahn <greg_at_structureddata.org> wrote:

> On Wed, Mar 23, 2011 at 8:59 AM, Niall Litchfield
> <niall.litchfield_at_gmail.com> wrote:
> > I must admit I'd like
> > the ability to tell oracle that 5% (or 50%) change made things stale
> instead
> > of a fixed (undocumented if you use the default job) parameter. If anyone
> > incorrectly picks arbitrary values on my database it should be me!
>
> You can do exactly that via DBMS_STATS.SET_TABLE_PREFS( <owner>,
> <table>, pname=> 'STALE_PERCENT', pvalue=>'5');
>
> http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/d_stats.htm#BEIBJJHC
>
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 23 2011 - 11:57:07 CDT