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@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 - 13:04:32 CDT