AUTOMATIC STATISTICS COLLECTION JOBS
- A scheduler job GATHER_STATS_JOB is pre-defined upon installation of an Oracle Database. GATHER_STATS_JOB collects optimizer statistics for all objects in the database for which there are no statistics or only stale statistics. If preference is to manage statistics collection manually, then disable the job by running EXECUTE DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB'); procedure.
- The 10g database automatically monitors the database's objects and updates the DBA_TAB_MODIFICATIONS view via SMON at approximately 3 hour intervals.
- To force up-to-date figures into the DBA_TAB_MODIFICATIONS view, use the DIMS_STATS.FLUSH_DATABASE_MONITORING_INFO; procedure.
- The automatic collection can be completely turned off by setting the init.ora parameter STATISTICS_LEVEL to BASIC, however this will also suppress many other useful management functions and is therefore not recommended by Oracle.
page revision: 6, last edited: 16 Sep 2010 08:40