摘自基于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