We have the below warning message in Oracle alert log.
“Too many parse errors, count=89508 SQL hash=0x178dfb39”
Is there a way to identify the actual SQL behind this error using this hash number?
Best Regards
-Kelum
Question
How to find SQL ID using hash number in alert log
+18
Not sure what the “SQL hash” is in your alert log, it don’t look like a sql hash_value” which is numeric, it might be a sql_id?
Is there a corresponding trc file?
“Hash values” or sql_id should be noted as this in trace files i think.
hv=2855441354 or sqlid='6c1rnb09dp921'
both sql_id and hash_value can be found in v$sql view.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.