Skip to main content

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

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.

Reply


Terms & ConditionsCookie settings