问题描述
近期发现日志文件中多次出现硬解析错误,不知道如何定位和拆除此警示信息。
2019-04-29T08:13:25.483287+08:00
WARNING: too many parse errors, count=256 SQL hash=0x750004bb
PARSE ERROR: ospid=16152, error=933 for statement:
2019-04-29T08:13:25.483384+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x55c447180 phd=0x1be486170 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
2019-04-29T08:13:25.483496+08:00
----- PL/SQL Call Stack -----
object line object
handle number name
0x1ff8ccb70 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
0x1efdb6970 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
0x1efdb6970 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
0x12cc84c78 1 anonymous block
专家解答
此问题是由于应用补丁28390461的时候未执行Prvtsqli.plb脚本,建议根据MOS文档Encountering Error 'WARNING: too many parse errors' After Applying WINDOWS DB BUNDLE PATCH 12.2.0.1.181016WINDBBP (文档 ID 2466404.1)的建议重新在数据库端执行以下脚本
Re-load the script in the database by running:
sqlplus ‘/ as sysdba’
@?/rdbms/admin/prvtsqli.plb