Re: Run stats on the basis of data increase
- From: Saad Khan <saad4u@xxxxxxxxx>
- To: Kenneth Naim <kennaim@xxxxxxxxx>
- Date: Wed, 3 Jun 2009 13:36:12 -0400
Thanks Ken. I wasnt aware of this option. Is there any performance impact if
we run the stats daily using this option?
On Wed, Jun 3, 2009 at 12:48 PM, Kenneth Naim <kennaim@xxxxxxxxx> wrote:
> 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.
>
>
Other related posts:
