Encountering Error 'WARNING: too many parse errors' After Applying WINDOWS DB BUNDLE PATCH 12.2.0.1.181016WINDBBP
(Doc ID 2466404.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterMicrosoft Windows x64 (64-bit)
Symptoms
- After applying WINDOWS DB BUNDLE PATCH 12.2.0.1.181016WINDBBP, following error is dumped in tracefile:
WARNING: too many parse errors, count=100 SQL hash=0x750004bb
PARSE ERROR: ospid=6000, error=933 for statement:
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=00007FF83DE8B810 phd=00007FF83DE8CF68 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
----- PL/SQL Call Stack -----
object line object
handle number name
00007FF83DEC8290 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
00007FF83F7A03A8 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
00007FF83F7A03A8 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
00007FF83F802B58 1 anonymous block
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |