Re: auto stats collection

From: Robert Freeman <>
Date: Wed, 18 Nov 2009 18:23:49 -0800 (PST)
Message-ID: <>



 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
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

From: Joe Smith <>
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?

Windows 7: It works the way you want. Learn more.
Received on Wed Nov 18 2009 - 20:23:49 CST

Original text of this message