日志文件中有大量该提示信息，能否关闭该提示信息。
其次也发现下面的错误日志
2019-08-26T21:00:29.933705+08:00
Archived Log entry 8455 added for T-1.S-3989 ID 0x85e56dfd LAD:1
2019-08-26T21:59:49.872881+08:00
Setting Resource Manager CDB plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-08-26T22:10:38.082376+08:00
Thread 1 advanced to log sequence 3991 (LGWR switch)
Current log# 1 seq# 3991 mem# 0: +DATA/JSZXORCL/ONLINELOG/group_1.262.990479999
Current log# 1 seq# 3991 mem# 1: +FIR/JSZXORCL/ONLINELOG/group_1.257.990480001
2019-08-26T22:10:38.323409+08:00
Archived Log entry 8458 added for T-1.S-3990 ID 0x85e56dfd LAD:1
2019-08-26T22:10:45.172430+08:00
WARNING: too many parse errors, count=650 SQL hash=0x750004bb
PARSE ERROR: ospid=15583, error=933 for statement:
2019-08-26T22:10:45.172529+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x1b772a3a8 phd=0x1b9754ec8 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
2019-08-26T22:10:45.172645+08:00
----- PL/SQL Call Stack -----
object line object
handle number name
0x103a112b8 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
0x1efdb6970 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
0x1efdb6970 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
0x12b0ca410 1 anonymous block
WARNING: too many parse errors, count=750 SQL hash=0x750004bb
PARSE ERROR: ospid=15583, error=933 for statement:
2019-08-26T22:10:45.306015+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x1b772a3a8 phd=0x1b9754ec8 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
2019-08-26T22:10:45.306125+08:00
----- PL/SQL Call Stack -----
object line object
handle number name
0x103a112b8 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
0x1efdb6970 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
0x1efdb6970 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
0x12b0ca410 1 anonymous block
来一个AWR报告看看。
WARNING: too many parse errors, count=650 SQL hash=0x750004bb
这个提示是说 SQL 有大量的解析失败。
评论
有用 0从标题看AFD can not be installed/loaded because ASMLib is installed
这个问题是因为已经启用了ASMLib，在安装的时候就不要选AFD。
评论 有用 02019-07-03T00:00:23.454542+08:00
TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P6310 (3470) VALUES LESS THAN (TO_DATE(' 2019-07-03 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-07-03T00:08:18.409150+08:00
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P6311 (43648) VALUES LESS THAN (TO_DATE(' 2019-07-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P6314 (43648) VALUES LESS THAN (TO_DATE(' 2019-07-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-07-03T00:28:23.561927+08:00
Thread 1 advanced to log sequence 3254 (LGWR switch)
Current log# 2 seq# 3254 mem# 0: +DATA/JSZXORCL/ONLINELOG/group_2.263.990479999
Current log# 2 seq# 3254 mem# 1: +FIR/JSZXORCL/ONLINELOG/group_2.258.990480001
2019-07-03T00:28:23.760840+08:00
Archived Log entry 6893 added for T-1.S-3253 ID 0x85e56dfd LAD:1
2019-07-03T00:49:37.859987+08:00
JSZX(3):Resize operation completed for file# 12, old size 5114880K, new size 5181440K
2019-07-03T01:00:31.926606+08:00
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P6315 (3471) VALUES LESS THAN (TO_DATE(' 2019-07-04 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P6316 (3471) VALUES LESS THAN (TO_DATE(' 2019-07-04 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-07-03T01:18:31.082466+08:00
Thread 1 advanced to log sequence 3255 (LGWR switch)
Current log# 1 seq# 3255 mem# 0: +DATA/JSZXORCL/ONLINELOG/group_1.262.990479999
Current log# 1 seq# 3255 mem# 1: +FIR/JSZXORCL/ONLINELOG/group_1.257.990480001
2019-07-03T01:18:31.240203+08:00
Archived Log entry 6894 added for T-1.S-3254 ID 0x85e56dfd LAD:1
2019-07-03T01:59:49.409684+08:00
Closing Resource Manager plan via scheduler window
Clearing Resource Manager CDB plan via parameter
2019-07-03T03:56:48.799926+08:00
JSZX(3):Resize operation completed for file# 12, old size 5181440K, new size 5191680K
2019-07-03T04:16:58.862675+08:00
Thread 1 advanced to log sequence 3256 (LGWR switch)
Current log# 2 seq# 3256 mem# 0: +DATA/JSZXORCL/ONLINELOG/group_2.263.990479999
Current log# 2 seq# 3256 mem# 1: +FIR/JSZXORCL/ONLINELOG/group_2.258.990480001
2019-07-03T04:16:59.041800+08:00
Archived Log entry 6895 added for T-1.S-3255 ID 0x85e56dfd LAD:1
评论 有用 0
