Automatic gather stats job

Posted on 5 March 2010 by Andrew Fraser

check it is on with:

select state, last_start_date from dba_scheduler_jobs where job_name = 'GATHER_STATS_JOB' ;

Switch it on and off with:

exec dbms_scheduler.disable('GATHER_STATS_JOB')
exec dbms_scheduler.enable('GATHER_STATS_JOB')

This entry was posted in Performance tuning, Stats. Bookmark the permalink.