WARNING: too many parse errors

bestsun999

已于 2023-05-02 22:53:15 修改

阅读量684

点赞数

文章标签：数据库 oracle

于 2023-04-26 19:29:17 首次发布

本文链接：https://blog.csdn.net/kevinyu998/article/details/130392973

版权

12.2c环境，alert日志中报错如下

WARNING: too many parse errors, count=12231 SQL hash=0x750004bb
PARSE ERROR: ospid=18015, error=933 for statement:
2023-04-24T19:21:35.983905+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x2affa19c0 phd=0x2abf6eed0 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0

WARNING: too many parse errors, count=12231 SQL hash=0x750004bb
PARSE ERROR: ospid=18015, error=933 for statement:
2023-04-24T19:33:35.983905+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x2affa19c0 phd=0x2abf6eed0 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0

WARNING: too many parse errors, count=12231 SQL hash=0x750004bb
PARSE ERROR: ospid=18015, error=933 for statement:
2023-04-24T19:45:35.983905+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x2affa19c0 phd=0x2abf6eed0 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0

不解释了，直接处理办法

SQL > alter system set "_kks_parse_error_warning"=0 scope=both;