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.

Other related posts: