Re: auto stats collection
From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 18 Nov 2009 18:23:49 -0800 (PST)
Message-ID: <519459.88271.qm_at_web113204.mail.gq1.yahoo.com>
Date: Wed, 18 Nov 2009 18:23:49 -0800 (PST)
Message-ID: <519459.88271.qm_at_web113204.mail.gq1.yahoo.com>
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_at_hotmail.com> To: oracle-l_at_freelists.org 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 18 2009 - 20:23:49 CST