暂无图片
分享
信仰
2019-03-28
oralce 12.2数据库突然间链接超时查询超时,查看alert日志报错WARNING: too many parse errors, count=100 SQL hash=0x750004bb

以下还部分alert的报错:

Checkpoint not complete

  Current log# 9 seq# 3624 mem# 0: /home/u01/app/oracle/oradata/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/oradata/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 


收藏
分享
2条回答
默认
最新
lastwinner

日志中

“DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name”


很显然,where条件和表名连在一起了,导致了解析错误

暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏