auto stats collection
From: Joe Smith <joe_dba_at_hotmail.com>
Date: Wed, 18 Nov 2009 19:08:12 -0600
Message-ID: <BLU108-W27F91B6F8A251834690C9997A20_at_phx.gbl>
Windows 7: It works the way you want. Learn more. http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen:112009v2
Date: Wed, 18 Nov 2009 19:08:12 -0600
Message-ID: <BLU108-W27F91B6F8A251834690C9997A20_at_phx.gbl>
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.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen:112009v2
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 18 2009 - 19:08:12 CST