oracle中的自动统计信息收集

摘自基于orcle的sql优化

10g:

查看收集的job

SQL> select job_name,program_name,schedule_name,last_start_date from dba_scheduler_jobs where job_name='GATHER_STATS_JOB';


JOB_NAME             PROGRAM_NAME                   SCHEDULE_NAME                            LAST_START_DATE
-------------------- ------------------------------ ---------------------------------------- -------------------------------------------
-------------
GATHER_STATS_JOB     GATHER_STATS_PROG              MAINTENANCE_WINDOW_GROUP                 23-5月 -15 08.01.16.987000 上午 +08:00

查看program对应的存储过程

SQL> select program_name,program_action from dba_scheduler_programs where program_name='GATHER_STATS_PROG';


PROGRAM_NAME         PROGRAM_ACTION
-------------------- --------------------------------------------------
GATHER_STATS_PROG    dbms_stats.gather_database_stats_j