RE: application deadlock ORA-00060

From: Allen, Brandon <>
Date: Fri, 11 Apr 2008 09:04:52 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450B36237C@NT15.oneneck.corp>

In 10g+, bind variables are also occasionally captured in v$sql_bind_capture, and dba_hist_sql_bind (but keep in mind a Diagnostics Pack is required for accessing all dba_hist views). I'm not sure exactly how Oracle decides when to capture the bind variables in these views, maybe only when the query is hard parsed.  


Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Fri Apr 11 2008 - 11:04:52 CDT

Original text of this message