Automatic Statistics Collection Job - Oracle 10g

A 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');

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 10g Topics