RE: determining bind values in deadlock situations

That is not correct ;)

What you see in lmd trace below is two copies of the same SQL for one session and two copies of the same SQL for the other session. As the trace data itself says it's the "Current SQL" just dumped twice, not "past SQL" or "SQL doing the locking".

Run your test case with 4 *distinct* SQL statements and you'll see only 2 of them, the currently executed ones are shown.

--
Regards,
Tanel Poder
http://blog.tanelpoder.com





> -----Original Message-----

> From: Barun, Vlado [mailto:Vlado.Barun_at_JTV.com] 

> Sent: 04 March 2009 06:28

> To: Bobak, Mark; tanel_at_poderc.com; oracle-l_at_freelists.org

> Subject: RE: determining bind values in deadlock situations

> 

> That is not correct.

> 

> Sql_a, sql_b, sql_c and sql_d are in the lmd0 trace files in 

> a RAC environment, assuming you have the necessary patches 

> applied (in my case 4441119 for 10.2.0.3 RAC/ASM on Solaris 10).

> 

> 

> Following is a test case:

> 


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