select window_group_name, enabled, comments -- next_start_date, -- number_of_windows from dba_scheduler_window_groups; -- -- WINDOW_GROUP_NAME ENABL COMMENTS -- ------------------------- ----- -------------------------------------- -- MAINTENANCE_WINDOW_GROUP TRUE Window group for Automated Maintenance -- ORA$AT_WGRP_OS TRUE auto optimizer stats collection -- ORA$AT_WGRP_SA TRUE auto space advisor -- ORA$AT_WGRP_SQ TRUE sql tuning advisor
dba_scheduler_windows
). The membership is listed in dba_scheduler_wingroup_members
.