Re: auto stats collection

Look at DBA_OPTSTAT_OPERATIONS.

RF

 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide 
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com




________________________________
From: Joe Smith <joe_dba@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Wed, November 18, 2009 6:08:12 PM
Subject: auto stats collection

 How can I tell when the auto stats job in Oracle 10gRelease2 is done?  I know 
the auto stats job is based on the
undocumented  procedure  GATHER_DATABASE_STATS_JOB_PROC in the DBMS_STATS 
package.
 
 
I want to run a job after the stats job completes, but I don’t want to query 
dba_scheduler_running_jobs
every minute.  I don’t want to start it after the window completes at 6am in 
the morning.  Our stats collection will most likely take 30 minutes to 1 hour.
 
Is there a way to determine when the GATHER_DATABASE_STATS_JOB_PROC has 
finished?
 
thanks.
 

________________________________
Windows 7: It works the way you want. Learn more.

Other related posts: