**************************************************************************************** * Description: SQL for quering Oracle database statistics gathering maintenance windows * Date: 11:03 AM EST, 12/20/2017 **************************************************************************************** <1> SQL for checking database maintenance windows: | |__ SQL> select window_name, repeat_interval, duration from dba_scheduler_windows where window_name like 'WEEK%'; 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
Your Comments