Re: LOCK problems on RAC

From: Mladen Gogala <mgogala.SPAM-ME_at_not-at-verizon.net>
Date: Tue, 8 May 2007 16:31:18 +0200 (CEST)
Message-ID: <pan.2007.05.08.14.25.01@not-at-verizon.net>

On Tue, 08 May 2007 06:55:14 -0700, Cristian Cudizio wrote:

> So, in my case it seems as more than one session has subexclusive table
> lock, SX (lmode 3) on
> the same record and one locking the others (a particular case of
> deadlock).
>
> Any ideas?

Different sessions can have RX lock on the same table. It simply makes them "interested". Those sessions still have to wait for an exclusive row lock (type=TX, mode=6).

-- 
http://www.mladen-gogala.com

Received on Tue May 08 2007 - 09:31:18 CDT