Oracle 统计信息窗口的相关知识-白红宇

Oracle 统计信息窗口的相关知识

阅读量：4514 次

发布时间：2019-06-08

本文共 4391 字，大约阅读时间需要 14 分钟。

生产环境有一套库从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 DISABLEDTUESDAY_WINDOW                 27-NOV-18 10.00.00.000000 PM +08:00      FALSE ENABLED  ENABLED  DISABLED DISABLED DISABLEDWEDNESDAY_WINDOW               28-NOV-18 10.00.00.000000 PM +08:00      FALSE ENABLED  ENABLED  DISABLED DISABLED DISABLEDTHURSDAY_WINDOW                29-NOV-18 10.00.00.000000 PM +08:00      FALSE ENABLED  ENABLED  DISABLED DISABLED DISABLEDFRIDAY_WINDOW                  30-NOV-18 10.00.00.000000 PM +08:00      FALSE ENABLED  ENABLED  DISABLED DISABLED DISABLEDSATURDAY_WINDOW                01-DEC-18 06.00.00.000000 AM +08:00      FALSE ENABLED  ENABLED  DISABLED DISABLED DISABLEDSUNDAY_WINDOW                  02-DEC-18 06.00.00.000000 AM +08:00      FALSE ENABLED  ENABLED  DISABLED DISABLED DISABLED

******************** 查询窗口的持续时间 ********************

DBA_AUTOTASK_WINDOW_HISTORYCLIENT_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=0WEEKEND_WINDOW                 freq=daily;byday=SAT;byhour=0;byminute=0 +002 00:00:00                            FALSE                               ;bysecond=0MONDAY_WINDOW                  freq=daily;byday=MON;byhour=22;byminute= +000 04:00:00                            TRUE                               0; bysecond=0TUESDAY_WINDOW                 freq=daily;byday=TUE;byhour=22;byminute= +000 04:00:00                            TRUE                               0; bysecond=0WINDOW_NAME                    REPEAT_INTERVAL                          DURATION                                 ENABL------------------------------ ---------------------------------------- ---------------------------------------- -----WEDNESDAY_WINDOW               freq=daily;byday=WED;byhour=22;byminute= +000 04:00:00                            TRUE                               0; bysecond=0THURSDAY_WINDOW                freq=daily;byday=THU;byhour=22;byminute= +000 04:00:00                            TRUE                               0; bysecond=0FRIDAY_WINDOW                  freq=daily;byday=FRI;byhour=22;byminute= +000 04:00:00                            TRUE                               0; bysecond=0SATURDAY_WINDOW                freq=daily;byday=SAT;byhour=6;byminute=0 +000 20:00:00                            TRUEWINDOW_NAME                    REPEAT_INTERVAL                          DURATION                                 ENABL------------------------------ ---------------------------------------- ---------------------------------------- -----                               ; bysecond=0SUNDAY_WINDOW                  freq=daily;byday=SUN;byhour=6;byminute=0 +000 20:00:00                            TRUE                               ; bysecond=0

********************查询窗口的持续时间********************

转载于:https://www.cnblogs.com/dayu-liu/p/10031157.html

你可能感兴趣的文章

Ubuntu/CentOS下使用脚本自动安装 Docker

查看>>

源码解读Mybatis List列表In查询实现的注意事项

查看>>

POJ 2311 Cutting Game(二维SG+Multi-Nim)

查看>>

小强的HTML5移动开发之路（16）——神奇的拖放功能

查看>>

zookeeper FastLeaderElection

HTTP报文（面试会问开发时常用的报文头格式）

Programming Erlang_CHAPTER2_Basic Erlang 学习笔记（2）。

在webstorm开发微信小程序之使用阿里自定义字体图标

查看>>

序列化模块/模块/包

查看>>

eclipse maven plugin 插件安装和配置

查看>>