How to identify SQL text per alert log SQL Hash?
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.