Database - RAC/Scalability (MOSC)

MOSC Banner

Oracle 12.2.1.0 RAC performance issue,

Noticed below warning message in the DB alert log, which drains the system performance. can some one suggest how we can handle this..

2021-12-04T23:57:54.994817+02:00

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

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

2021-12-04T23:57:54.995095+02:00

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

Additional information: hd=0xde4738d8 phd=0xde474b08 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0 

Also noticed after this error, most of the select queries which are triggered from application access are throwing parse warnings in the alert log, this results in slow down the system gradually,

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