RE: determining bind values in deadlock situations

  • From: Yong Huang <yong321@xxxxxxxxx>
  • To: Vlado.Barun@xxxxxxx
  • Date: Tue, 3 Mar 2009 10:18:36 -0800 (PST)

> 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


      
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2009