Re: auto stats collection

From: Fuyuncat <fuyuncat_at_gmail.com>
Date: Thu, 19 Nov 2009 10:55:29 +0800
Message-ID: <441b79840911181855y8f93c03y5c4b9ce3a9470742_at_mail.gmail.com>

You may turn on the tracing of the stats gathering job by this command.

exec dbms_stats.set_param('TRACE',512);

It will generate a trace file under the udump folder, logged the events such as the job start/finish, as well as error alert.

2009/11/19 Joe Smith <joe_dba_at_hotmail.com>

> 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>
>

-- 
Sr. DBA Fuyuncat
www.HelloDBA.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 18 2009 - 20:55:29 CST