Automatic Statistics Collection Job - Oracle 10g
Interview Questions
Practice Test
Pragnyameter Exam
All Tutorials
Job SearchA Scheduler program GATHER _STATS _PROG and Scheduler job GATHER _STATS _JOB are predefined on installation of Oracle Database. GATHER _STATS _PROG collects optimizer statistics for all objects in the database for which there are no statistics or only stale statistics. GATHER _STATS _JOB is defined on GATHER_ STATS _PROG and is scheduled to run in the MAINTENANCE _WINDOW _GROUP.
If you prefer to manage statistics collection manually, you can disable the job as follows:
EXECUTE DBMS _SCHEDULER.DISABLE('GATHER_STATS_JOB');
