Database Administration (MOSC)

MOSC Banner

Why too many parsing errors in oracle database version 12.2.0.1.0 ?

In alert log I found the following warning

WARNING: too many parse errors, count=15026 SQL hash=0x750004bb

PARSE ERROR: ospid=119394, error=933 for statement:

2022-02-17T06:25:47.026142+06:00

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

Additional information: hd=0x13ba02fe0 phd=0x13ba03238 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0

2022-02-17T06:25:47.026212+06:00

----- PL/SQL Call Stack -----

 object   line object

 handle  number name

0x18dd17990    259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION

0x1e7f0aea0   2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK

0x1e7f0aea0   7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center