Re: Run stats on the basis of data increase
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: SMurphy@xxxxxxxxxxxxxxxxx
- Date: Wed, 3 Jun 2009 20:39:32 +0100
Indeed it does apply to both releases - and 11g too, and it appears from my
investigations to work exactly as the dbms_stats.gather_stale option does,
that is on the 10% basis that the OP originally asked for. So not only is
there a feature, but it's almost certainly running. If only all issues were
this simple.
regards
On Wed, Jun 3, 2009 at 6:41 PM, Stephen T Murphy
<SMurphy@xxxxxxxxxxxxxxxxx>wrote:
> Oracle 10gR2 (and I think 10gR1) does this right out of the box. When you
> create a 10g database (or upgrade an earlier one) a DBMS_Scheduler job is
> created and scheduled to run sys.gather_stats-prog on a daily basis. It does
> stats for both missing and stale stats.
>
> --
> *---------------------------------------------------------------------------*
>
> Stephen T. Murphy
> Manager, Database and Technical Support
> ITS - University Applications Development
> MSC-100
> The University at Albany, S.U.N.Y.
> Albany, New York 12222
> Phone: (518) 437-4523 Fax: (518) 437-4540
> MailTo: SMurphy@xxxxxxxxxxxxxxxxx <%20SMurphy@xxxxxxxxxxxxxxxxx>
> AIM: SMurphy199
>
>
>
> ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Kenneth Naim
> *Sent:* Wednesday, June 03, 2009 12:49 PM
> *To:* saad4u@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> *Subject:* RE: Run stats on the basis of data increase
>
> You can schedule a regular (weekly/daily etc.) job to have stats
> gathered on objects that have changed more than 10% by using
> dbms_stats.gather_stale.
>
>
>
> Ken
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Saad Khan
> *Sent:* Wednesday, June 03, 2009 12:27 PM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Run stats on the basis of data increase
>
>
>
> Hi Fellows,
>
> I have oracle 10g running for an application on SUSE linux 10.
>
> I know I can schedule on the timing basis, but is there a way in Oracle to
> generate/gather stats on the basis of data growth? I mean, can I schedule
> the stats generation on the basis of the amount of data that is increased.
> Say its run if the data increases to 10% of what it is, right now. I didnt
> see any option myself but I just thought there may be anything that I'm
> unaware of.
>
> Thanks for your help.
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
