RE: determining bind values in deadlock situations

  • From: "Tanel Poder" <tanel@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 4 Mar 2009 04:37:56 +0200

A small correction,
 
I mixed up a level bit for systemstate dump. Systemstate dump at level 266
(256 + 10) will dump the short stacks of processes, I initially wrote 522
(512 + 10) but thats wrong.
 
Tanel.
--
Regards,
Tanel Poder
 <http://blog.tanelpoder.com/> http://blog.tanelpoder.com



 



  _____  

From: Barun, Vlado [mailto:Vlado.Barun@xxxxxxx] 
Sent: 04 March 2009 04:07
To: tanel@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: determining bind values in deadlock situations



Tanel, thank you for the very useful information you posted on your blog
about this. 

 

One correction though to your statement ".but you don't necessarily know
when, why and by which statement these locks were taken for.". 

The lmd0 trace files do show the statements involved in the deadlock. Maybe
I'm misunderstanding your statement.

 

 

Other related posts: