Friday, November 23, 2012

Disable 11g gather stats

I know this is very simple,but here it is,


 col JOB_NAME for a30
 col START_DATE for a30
 col LAST_START_DATE for a30
 col NEXT_RUN_DATE for a30
select JOB_NAME,START_DATE,LAST_START_DATE,NEXT_RUN_DATE,JOB_ACTION from  DBA_SCHEDULER_JOBS where job_name like '%GATHER%'

SELECT owner, job_name, job_class, enabled FROM dba_scheduler_jobs;

exec dbms_scheduler.disable('GATHER_SYS_STATS_JOB');

No comments:

Post a Comment