oracle每晚22点收集,Oracle数据库11G自动收集统计信息实例

在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