Re: tracking down hidden SQL???
From: Nigel Antell <nigel.antell_at_antelopeconsulting.co.uk>
Date: Tue, 22 Oct 2013 08:53:01 +0100
Message-Id: <30660029-A409-47E5-8C5C-B42BC2EA1732_at_antelopeconsulting.co.uk>
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).-- http://www.freelists.org/webpage/oracle-l Received on Tue Oct 22 2013 - 09:53:01 CEST
Date: Tue, 22 Oct 2013 08:53:01 +0100
Message-Id: <30660029-A409-47E5-8C5C-B42BC2EA1732_at_antelopeconsulting.co.uk>
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).-- http://www.freelists.org/webpage/oracle-l Received on Tue Oct 22 2013 - 09:53:01 CEST