Default Stats Jobs
Submitted by dave on Fri, 07/29/2011 - 15:13
Show current Global defaults for object stats gathering
These can be set with the DBMS_STATS.SET_GLOBAL_PREFS procedure.
SELECT sname as Name,
SVAL1 || SPARE4 AS Value
FROM sys.optstat_hist_control$
ORDER BY 1;
View info About Nightly Stats Collection Jobs (10g)
SELECT JOB_NAME,
SCHEDULE_NAME,
JOB_CLASS,
RUN_COUNT,
LAST_START_DATE,
LAST_RUN_DURATION,
NEXT_RUN_DATE
FROM DBA_SCHEDULER_JOBS
WHERE JOB_NAME = 'GATHER_STATS_JOB';
View info About Nightly Stats Collection Jobs (11g)
select window_name, job_start_time, job_duration from dba_autotask_job_history where client_name = 'auto optimizer stats collection' order by job_start_time desc;