Database Tuning (MOSC)

MOSC Banner

parse error in alert log

edited Feb 4, 2025 3:59PM in Database Tuning (MOSC) 7 commentsAnswered

How can I find out which query is causing the parse errors? I tried v$sql but it does not have info according to the sql_id given in the alert log.

WARNING: too many parse errors, count=505 SQL hash=0xb6a91e8f
PARSE ERROR: ospid=5618, error=904:
Additional information: hd=0x1d6dae380 phd=0x1de7e1880 flg=0x20 cisid=108 sid=108 ciuid=108 uid=108 sqlid=fa9vmfqvak7ng
...Current username=RUDBA
...Application: OEM Action: [ACTIVE] ExecuteThread: '68' for

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