統計情報自動取得について調べる
１．実行ジョブについて
SQL> col JOB_NAME for a30
SQL> col SCHEDULE_NAME for a40
SQL> select JOB_NAME ,SCHEDULE_NAME from DBA_SCHEDULER_JOBS;
JOB_NAME SCHEDULE_NAME
------------------------------ ----------------------------------------
AUTO_SPACE_ADVISOR_JOB MAINTENANCE_WINDOW_GROUP
GATHER_STATS_JOB MAINTENANCE_WINDOW_GROUP
FGR$AUTOPURGE_JOB
PURGE_LOG DAILY_PURGE_SCHEDULE
２．WINDOW_GROUP詳細を調べる
SQL> col WINDOW_GROUP_NAME for a30
SQL> col WINDOW_NAME for a20
SQL> select WINDOW_GROUP_NAME ,WINDOW_NAME from DBA_SCHEDULER_WINGROUP_MEMBERS;
WINDOW_GROUP_NAME WINDOW_NAME
------------------------------ --------------------
MAINTENANCE_WINDOW_GROUP WEEKNIGHT_WINDOW
MAINTENANCE_WINDOW_GROUP WEEKEND_WINDOW
３．WINDOW詳細を調べる
SQL> col WINDOW_NAME for a20
SQL> col REPEAT_INTERVAL for a80
SQL> col DURATION for a30
SQL> select WINDOW_NAME ,REPEAT_INTERVAL ,DURATION from DBA_SCHEDULER_WINDOWS;
WINDOW_NAME REPEAT_INTERVAL DURATION
-------------------- -------------------------------------------------------------------------------- ------------------------------
WEEKNIGHT_WINDOW freq=daily;byday=MON,TUE,WED,THU,FRI;byhour=22;byminute=0; bysecond=0 +000 08:00:00
WEEKEND_WINDOW freq=daily;byday=SAT;byhour=0;byminute=0;bysecond=0 +002 00:00:00
参照：http://d.hatena.ne.jp/nijimass/20080619/1213878812
