oracle每晚22点收集,修改自动收集统计信息任务的执行时间

个小时

---查看自动统计信息的时间：

sys@PROD>col WINDOW_NAME for a15

sys@PROD>col REPEAT_INTERVAL for a60

sys@PROD>col DURATION for a30

sys@PROD>set linesize 120

sys@PROD>SELECT t1.window_name, t1.repeat_interval, t1.duration

2  FROM dba_scheduler_windows t1, dba_scheduler_wingroup_members t2

3  WHERE t1.window_name = t2.window_name

4  AND t2.window_group_name IN

5  ('MAINTENANCE_WINDOW_GROUP', 'BSLN_MAINTAIN_STATS_SCHED');

WINDOW_NAME     REPEAT_INTERVAL                                              DURATION

--------------- ------------------------------------------------------------ ------------------------------

MONDAY_WINDOW   freq=daily;byday=MON;byhour=22;byminute=0; bysecond=0        +000 04:00:00

TUESDAY_WINDOW  freq=daily;byday=TUE;byhour=