0

oralce 12.2 alert日志报错WARNING: too many parse errors

问题归档 2019-04-14
1023
摘要:以下还部分alert的报错:CheckpointnotcompleteCurrentlog#9seq#3624mem#0:/home/u0...

问题描述

以下还部分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条件和表名连在一起了,导致了解析错误

「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
最新发布
暂无内容,敬请期待...
数据库资讯
最新 热门 更多
本月热门
近期活动
全部
暂无活动,敬请期待...
相关课程
全部
暂无课程,敬请期待...