Re: puzzling deadlock
From: Richard Kuhler <noone_at_nowhere.com>
Date: Thu, 25 Sep 2003 18:04:32 GMT
Message-ID: <Q6Gcb.5434$Ak3.2260_at_twister.socal.rr.com>
Date: Thu, 25 Sep 2003 18:04:32 GMT
Message-ID: <Q6Gcb.5434$Ak3.2260_at_twister.socal.rr.com>
Brian Peasland wrote:
> You'll have to look more closely at the application's code. It is
> impossible for two concurrent sessions to issue just one DML statement
> and cause a deadlock.
Actually, there are at least 2 ways to cause a deadlock with just one statement in two concurrent sessions.
- out of transaction entries (see Note 115467.1 on Metalink)
- deadlock on bitmap index updates (see Note 171795.1 on Metalink)
In fact, with autonomous transactions, you can cause a deadlock in just one session.
Richard Kuhler Received on Thu Sep 25 2003 - 20:04:32 CEST