Re: Run stats on the basis of data increase

From: Saad Khan <saad4u_at_gmail.com>
Date: Wed, 3 Jun 2009 13:36:12 -0400
Message-ID: <76b3d4e30906031036l5b956a14o1674b655256c7cd1_at_mail.gmail.com>

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_at_gmail.com> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Saad Khan
> *Sent:* Wednesday, June 03, 2009 12:27 PM
> *To:* oracle-l_at_freelists.org
> *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.
>
>

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

Received on Wed Jun 03 2009 - 12:36:12 CDT