Re: tracking down hidden SQL???

From: Nigel Antell <>
Date: Tue, 22 Oct 2013 08:53:01 +0100
Message-Id: <>

If I understand correctly, the SQL_ID is visible in v$session, which means that you _should_ also get the SQL_HASH_VALUE. If you use this value to query v$db_object_cache via hash_value, one would hope you should see the SQL in the NAME column (or at least a truncated version if it is long).-- Received on Tue Oct 22 2013 - 09:53:01 CEST

Original text of this message