The GATHER_STATS_JOB (Automatic Statistics Collection) has suddenly stopped to run. What should I check?
First verify whether it is true that the GATHER_STATS_JOB is no longer running by querying the all_scheduler_job_log table. You’ll find entries in this table for each job run. If there are no recent entries for the GATHER_STATS_JOB, then make sure that the windows in the maintenance window group are still properly opening and closing by querying all_scheduler_window_log. If as you say the maintenance windows still properly open, then either the job has been – disabled, or – it’s schedule is no longer pointing to the window group As SYS issue the following query. The results should be similar. If the job isn’t even there it might have been deleted. To fix the schedule, or to enable the job you can use the routines in the dbms_scheduler package, or use EM. SQL> select schedule_name, enabled, state, last_start_date from all_scheduler_jobs where job_name = ‘GATHER_STATS_JOB’; SCHEDULE_NAME ———————————————————- ENABL STATE —– ————— LAST_STA
