Database Administration (MOSC)

MOSC Banner

How to identify SQL text per alert log SQL Hash?

edited Aug 8, 2020 5:00AM in Database Administration (MOSC) 11 commentsAnswered

Oracle 12.2, Linux Redhat, Cloud:AWS

I'm noting the following in my alert log...

WARNING: too many parse errors, count=6948 SQL hash=0x7a24861c
PARSE ERROR: ospid=4345, error=923 for statement:
SELECT :"SYS_B_0"
Additional information: hd=0x9177a8c0 phd=0x91e82320 flg=0x28 cisid=56 sid=56 ciuid=56 uid=56

The primary docs reviewed were Doc ID 2649163.1 and Doc ID 1353015.1.

I've identified the application by the uid.  But I'm having trouble identifying the offending SQL.

As you know, the SQL_ID is varchar2(13) and various hash value columns in the data dictionary are numeric.  The SQL Hash in the alert log is not.

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