在Oracle数据库11g中,默认自动收集统计信息的时间为晚上10点(周一到周五,4个小时),早上6点(周六,周日,20个小时),如下所示:[sql] view plain copy
1.select a.window_name, a.repeat_interval,a.duration
2. from dba_scheduler_windows a, dba_scheduler_wingroup_members b
3. where a.window_name = b.window_name
4. and b.window_group_name = 'MAINTENANCE_WINDOW_GROUP';
5.
6.WINDOW_NAME REPEAT_INTERVAL DURATION
7.------------------------------ ------------------------------------------------------------ --------------------
8.WEDNESDAY_WINDOW freq=daily;byday=WED;byhour=22;byminute=0; bysecond=0 +000 04:00:00
9.FRIDAY_WINDOW freq=daily;byday=FRI;byhour=22;byminute=0; bysecond=0 +000 04:00:00
10.SATURDAY_WINDOW freq=daily;byday=SAT;byhour=6;byminute=0; bysecond=0 +000 20:00:00
11.THURSDAY_WINDOW freq=daily;byday=THU;byhour=22;byminute=0; bysecond=0 +000 04:00:00
12.TUESDAY_WINDOW freq=daily;byday=TUE;byhour=22;byminute=0; bysecond=0 +000 04:00:00
13.SUNDAY_WINDOW freq=daily;byday=SUN;byhour=6;byminute=0; bysecond=0 +000 20:00:00
14.MONDAY_WINDOW freq=daily;byday=M