My Oracle Support Banner

Oracle 10g: Checklist To Diagnose Issues Related To Automatic Run Of Job GATHER_STATS_JOB (Doc ID 803191.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5.0 [Release 10.2]
Information in this document applies to any platform.
Checked for relevance on 19-Nov-2010


Goal

How to diagnose the issues where GATHER_STATS_JOB job is not running automatically in the maintenance windows. (WEEKEND_WINDOW, WEEKNIGHT_WINDOW)

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Step by Step Checklist
 1. Check if the GATHER_STATS_JOB exists in the database:
 2. Check the properties of the job GATHER_STATS_JOB:
 3. Check the log details from the following query:
 4. Check the run details from the following query:
 5. Check the status of the scheduler windows:
 6. Check if the WINDOWS are part of MAINTENANCE_WINDOW_GROUP
 7. Check STATISTICS_LEVEL parameter:
 8. Check for other equal or higher priority overlapping WINDOWS:
 9. Manually open the WINDOW (only for NON PRODUCTION databases):
 10. Recreate the GATHER_STATS_JOB and WINDOWS:
 11. Restart the database if possible:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.