Oracle 统计信息窗口的相关知识
生产环境有一套库从10月份开始,统计信息收集的动作就变的不正常,后来通过手动drop窗口,重新创建统计信息窗口解决。
****************
查询窗口状态
****************
select * from dba_autotask_window_clients;
WINDOW_NAME WINDOW_NEXT_TIME WINDO AUTOTASK OPTIMIZE SEGMENT_ SQL_TUNE HEALTH_M
------------------------------ ---------------------------------------- ----- -------- -------- -------- -------- --------
MONDAY_WINDOW 03-DEC-18 10.00.00.000000 PM +08:00 FALSE ENABLED ENABLED DISABLED DISABLED DISABLED
TUESDAY_WINDOW 27-NOV-18 10.00.00.000000 PM +08:00 FALSE ENABLED ENABLED DISABLED DISABLED DISABLED
WEDNESDAY_WINDOW 28-NOV-18 10.00.00.000000 PM +08:00 FALSE ENABLED ENABLED DISABLED DISABLED DISABLED
THURSDAY_WINDOW 29-NOV-18 10.00.00.000000 PM +08:00 FALSE ENABLED ENABLED DISABLED DISABLED DISABLED
FRIDAY_WINDOW 30-NOV-18 10.00.00.000000 PM +08:00 FALSE ENABLED ENABLED DISABLED DISABLED DISABLED
SATURDAY_WINDOW 01-DEC-18 06.00.00.000000 AM +08:00 FALSE ENABLED ENABLED DISABLED DISABLED DISABLED
SUNDAY_WINDOW 02-DEC-18 06.00.00.000000 AM +08:00 FALSE ENABLED ENABLED DISABLED DISABLED DISABLED
********************
查询窗口的持续时间
********************
DBA_AUTOTASK_WINDOW_HISTORY CLIENT_NAME WINDOW_NAME WINDOW_START_TIME WINDOW_DURATION JOBS_CREATED JOBS_STARTED JOBS_COMPLETED WINDOW_END_TIME -------------------- ------------------------------ ---------------------------------------- ---------------------------------------- ------------ ------------ -------------- --------------------------------------------------------------------------- auto optimizer stats MONDAY_WINDOW 26-NOV-18 10.00.00.531345 PM +08:00 +000000000 13:27:27.402436 1 1 0 27-NOV-18 11.27.27.933781 AM +08:00 collection
********************
查询窗口的持续时间、重复频次
********************
select window_name,repeat_interval,duration,enabled from dba_scheduler_windows;
WINDOW_NAME REPEAT_INTERVAL DURATION ENABL
------------------------------ ---------------------------------------- ---------------------------------------- -----
WEEKNIGHT_WINDOW freq=daily;byday=MON,TUE,WED,THU,FRI;byh +000 08:00:00 FALSE
our=22;byminute=0; bysecond=0
WEEKEND_WINDOW freq=daily;byday=SAT;byhour=0;byminute=0 +002 00:00:00 FALSE
;bysecond=0
MONDAY_WINDOW freq=daily;byday=MON;byhour=22;byminute= +000 04:00:00 TRUE
0; bysecond=0
TUESDAY_WINDOW freq=daily;byday=TUE;byhour=22;byminute= +000 04:00:00 TRUE
0; bysecond=0
WINDOW_NAME REPEAT_INTERVAL DURATION ENABL
------------------------------ ---------------------------------------- ---------------------------------------- -----
WEDNESDAY_WINDOW freq=daily;byday=WED;byhour=22;byminute= +000 04:00:00 TRUE
0; bysecond=0
THURSDAY_WINDOW freq=daily;byday=THU;byhour=22;byminute= +000 04:00:00 TRUE
0; bysecond=0
FRIDAY_WINDOW freq=daily;byday=FRI;byhour=22;byminute= +000 04:00:00 TRUE
0; bysecond=0
SATURDAY_WINDOW freq=daily;byday=SAT;byhour=6;byminute=0 +000 20:00:00 TRUE
WINDOW_NAME REPEAT_INTERVAL DURATION ENABL
------------------------------ ---------------------------------------- ---------------------------------------- -----
; bysecond=0
SUNDAY_WINDOW freq=daily;byday=SUN;byhour=6;byminute=0 +000 20:00:00 TRUE
; bysecond=0
******************** 查询窗口的持续时间 ********************
![](https://img2018.cnblogs.com/blog/1316780/201811/1316780-20181128113425693-1193489890.png)