RE: determining bind values in deadlock situations
From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 3 Mar 2009 10:18:36 -0800 (PST)
Message-ID: <911865.77364.qm_at_web80602.mail.mud.yahoo.com>
> There is no trace file generated for a deadlock in udump on any of my RAC nodes...
Date: Tue, 3 Mar 2009 10:18:36 -0800 (PST)
Message-ID: <911865.77364.qm_at_web80602.mail.mud.yahoo.com>
> There is no trace file generated for a deadlock in udump on any of my RAC nodes...
Vlado,
In RAC, you need to check lmd trace files in bdump for the deadlock trace.
Bind variable values are not available in the trace. In fact, if the involved sessions are all on the same node, even the SQL is not in the trace. If you do get the SQL, you may be able to find the SQL in v$sql% view(s), and may find the bind variable value in v$sql_bind_capture.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 03 2009 - 12:18:36 CST