问题描述
以下还部分alert的报错:
Checkpoint not complete
Current log# 9 seq# 3624 mem# 0: /home/u01/app/oracle/ora/orcl/redo09.log
2019-03-28T12:04:39.886671+08:00
Restarting dead background process MMON
Starting background process MMON
2019-03-28T12:04:40.088642+08:00
MMON started with pid=36, OS id=2093
2019-03-28T12:08:56.288035+08:00
Thread 1 advanced to log sequence 3625 (LGWR switch)
Current log# 4 seq# 3625 mem# 0: /home/u01/app/oracle/ora/orcl/redo04.log
2019-03-28T12:08:58.229014+08:00
WARNING: too many parse errors, count=100 SQL hash=0x750004bb
PARSE ERROR: ospid=3128, error=933 for statement:
2019-03-28T12:08:58.229154+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x145698a48 phd=0x4161198a8 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
2019-03-28T12:08:58.229304+08:00
----- PL/SQL Call Stack -----
object line object
handle number name
0x1adc2a6e8 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
0x1b7b26180 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
0x1b7b26180 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
0x557dee138 1 anonymous block
WARNING: too many parse errors, count=200 SQL hash=0x750004bb
PARSE ERROR: ospid=3128, error=933 for statement:
2019-03-28T12:08:58.447916+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x145698a48 phd=0x4161198a8 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
专家解答
日志中
“DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name”
很显然,where条件和表名连在一起了,导致了解析错误