DEFAULT_MAINTENANCE_PLAN---激活的资源计划
dba_scheduler_jobs中SCHEDULE_NAME为MAINTENANCE_WINDOW_GROUP及窗口组
select * from dba_scheduler_window_groups; 可以查看此窗口组
select * from dba_scheduler_wingroup_members; 可以查看此窗口组有哪些WINDOW
select a.window_name,a.resource_plan,a.repeat_interval from dba_scheduler_windows a; 可以看到其激活的时间
除了此处我们还要注意11G新加入的一些自动任务
select * from dba_autotask_client;
其WINDOW_GROUP组为ORA$AT_WGRP_OS，ORA$AT_WGRP_SA，ORA$AT_WGRP_SQ
查看其select * from dba_scheduler_wingroup_members;其实依然是
MONDAY_WINDOW
TUESDAY_WINDOW
WEDNESDAY_WINDOW
THURSDAY_WINDOW
FRIDAY_WINDOW
SATURDAY_WINDOW
SUNDAY_WINDOW
这样我们可以看他们对应的实际都是
select a.window_name,a.resource_plan,a.repeat_interval from dba_scheduler_windows a;
DEFAULT_MAINTENANCE_PLAN
为了区分其优先级的高低通过资源组的消耗者组决定
SQL> select a.client_name,a.consumer_group from dba_autotask_client a;
CLIENT_NAME CONSUMER_GROUP
---------------------------------------------------------------- ------------------------------
auto optimizer stats collection ORA$AUTOTASK_STATS_GROUP
auto space advisor ORA$AUTOTASK_SPACE_GROUP
sql tuning advisor ORA$AUTOTASK_SQL_GROUP
实际上这些组是DEFAULT_MAINTENANCE_PLAN中子计划ORA$AUTOTASK_SUB_PLAN子计划ORA$AUTOTASK_HIGH_SUB_PLAN中定义的。
select * from dba_rsrc_plan_directives where plan not like 'DSS%' and plan not like 'ETL%' and plan not like 'MIXED%' order by plan;
可以查看其定义。而且他的作业时SYS用户的OWNER其执行组应该都是SYS_GROUP，可以看到dba_rsrc_group_mappings
