Show Scheduled Windows
--
-- Window group details.
--
 
SET HEADING ON
SET LINESIZE 300
SET PAGESIZE 60
COLUMN comments FORMAT A40
 
SELECT window_group_name,
enabled,
number_of_windows,
comments
FROM   dba_scheduler_window_groups
ORDER BY window_group_name;
 
SELECT window_group_name,
window_name
FROM   dba_scheduler_wingroup_members
ORDER BY window_group_name, window_name
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License