****************************************************************************************
* 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