0

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

问题归档 2019-04-14
1892

问题描述

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

最后修改时间:2019-04-14 14:35:41
「喜欢文章,快来给作者赞赏墨值吧」
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

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