Re: determining bind values in deadlock situations
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Vlado.Barun@xxxxxxx
- Date: Fri, 27 Feb 2009 11:56:43 -0800
On Fri, Feb 20, 2009 at 5:33 PM, Barun, Vlado <Vlado.Barun@xxxxxxx> wrote:
> Environment: 10.2.0.3 RAC/ASM on Solaris 10
>
> I’m trying to find an efficient way to get the bind values for statements
> that are involved in a deadlock situation.
>
>
Maybe I am just being particularly dense today, but I can't think of why
you would need bind variables to resolve a deadlock.
The ORA-60 deadlock is caused by an application error, typically two
different parts of an application causing a deadly embrace by trying
to lock the same tables, but in different orders.
The trace file generated by the ORA-60 contains the SQL and the
rowid's of the affected rows.
Is there something I am missing?
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
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