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:
- » determining bind values in deadlock situations- Barun, Vlado
- » Re: determining bind values in deadlock situations- Jared Still
- » Re: determining bind values in deadlock situations- Jared Still
- » RE: determining bind values in deadlock situations- Bobak, Mark
- » RE: determining bind values in deadlock situations- Barun, Vlado
- » RE: determining bind values in deadlock situations- Barun, Vlado
- » Re: determining bind values in deadlock situations- Stefan Knecht
- » RE: determining bind values in deadlock situations- Joel Wittenmyer
- » RE: determining bind values in deadlock situations- Yong Huang
- » Re: determining bind values in deadlock situations- Scott
- » RE: determining bind values in deadlock situations- Barun, Vlado
- » RE: determining bind values in deadlock situations- Barun, Vlado
- » RE: determining bind values in deadlock situations- Yong Huang
- » RE: determining bind values in deadlock situations- Tanel Poder
- » RE: determining bind values in deadlock situations- Barun, Vlado
- » RE: determining bind values in deadlock situations - Tanel Poder
- » RE: determining bind values in deadlock situations- Bobak, Mark
- » RE: determining bind values in deadlock situations- Barun, Vlado
- » RE: determining bind values in deadlock situations- Bobak, Mark
- » RE: determining bind values in deadlock situations- Tanel Poder
- » RE: determining bind values in deadlock situations- Barun, Vlado
- » RE: determining bind values in deadlock situations- Barun, Vlado
- » Re: determining bind values in deadlock situations- Joel Wittenmyer
- » Re: determining bind values in deadlock situations- Jared Still
- » RE: determining bind values in deadlock situations- Barun, Vlado
- » RE: determining bind values in deadlock situations- Joel Wittenmyer