暂无图片
分享
Donnieyen
2019-12-27
日志大概信息PAYENGINE(7):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P7599 (43824) VALUES LESS THAN

2019-12-26T02:00:00.717319+08:00
Closing Resource Manager plan via scheduler window
Clearing Resource Manager CDB plan via parameter
2019-12-26T03:00:36.574389+08:00
Thread 2 advanced to log sequence 6114 (LGWR switch)
Current log# 4 seq# 6114 mem# 0: +DATA/ORCL/ONLINELOG/group_4.271.990480273
Current log# 4 seq# 6114 mem# 1: +FIR/ORCL/ONLINELOG/group_4.260.990480275
2019-12-26T03:00:36.786419+08:00
Archived Log entry 11852 added for T-2.S-6113 ID 0x85e56dfd LAD:1
2019-12-26T06:00:00.266749+08:00
JSZX(3):Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
CUSTOMER(4):Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
CASHIER(5):Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-12-26T06:00:00.748425+08:00
SUPERGW(6):Setting Resource Manager plan SCHEDULER[0x4ABF]:DEFAULT_MAINTENANCE_PLAN via scheduler window
SUPERGW(6):Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
PAYENGINE(7):Setting Resource Manager plan SCHEDULER[0x4ABF]:DEFAULT_MAINTENANCE_PLAN via scheduler window
PAYENGINE(7):Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-12-26T06:00:17.055833+08:00
PAYENGINE(7):TABLE SYS.WRIOPTSTATHISTHEADHISTORY:ADDEDINTERVALPARTITIONSYSP7599(43824)VALUESLESSTHAN(TODATE(2019122700:00:00,SYYYYMMDDHH24:MI:SS,NLSCALENDAR=GREGORIAN))PAYENGINE(7):TABLESYS.WRI_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P7599 (43824) VALUES LESS THAN (TO_DATE(' 2019-12-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PAYENGINE(7):TABLE SYS.WRI_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P7602 (43824) VALUES LESS THAN (TO_DATE(’ 2019-12-27 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
2019-12-26T06:00:18.004654+08:00
CUSTOMER(4):TABLE SYS.WRIOPTSTATHISTHEADHISTORY:ADDEDINTERVALPARTITIONSYSP7455(43824)VALUESLESSTHAN(TODATE(2019122700:00:00,SYYYYMMDDHH24:MI:SS,NLSCALENDAR=GREGORIAN))CUSTOMER(4):TABLESYS.WRI_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P7455 (43824) VALUES LESS THAN (TO_DATE(' 2019-12-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) CUSTOMER(4):TABLE SYS.WRI_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P7458 (43824) VALUES LESS THAN (TO_DATE(’ 2019-12-27 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))

收藏
分享
2条回答
默认
最新
你好我是李白

以下答案来自 oracle community Mukeshs的回答:

SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY table is used to store historical statistics collection information for objects.

When collected data for AWR and similar OPTSTAT tables reaches an internally defined threshold volume of data, Oracle will automatically create

partitions . Thus AWR, SQLSETs and similar data is then stored in partitions including WRH/WRI based objects. This operation is done during the

maintenance window.

You can control retention period using the following

exec dbms_stats.alter_stats_history_retention (Number_of_days);

–> This will ensure that statistics history will be retained for at least # days.

This is an informational message, and not a warning or Error.

These messages cannot be suppressed.

暂无图片 评论
暂无图片 有用 0
Donnieyen
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏