Re: stats document links.
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Wed, 23 Mar 2011 09:45:15 -0700
On Wed, Mar 23, 2011 at 8:59 AM, Niall Litchfield
<niall.litchfield@xxxxxxxxx> 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
--
http://www.freelists.org/webpage/oracle-l
Other related posts: