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