暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片

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

原创 问题归档 2019-04-14
4006

问题描述

以下还部分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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论