RE: Run stats on the basis of data increase
- From: "Stephen T Murphy" <SMurphy@xxxxxxxxxxxxxxxxx>
- To: <kennaim@xxxxxxxxx>, <saad4u@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Jun 2009 13:41:12 -0400
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
<mailto:%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.
Other related posts:
