Re: LOCK problems on RAC

On Tue, 08 May 2007 03:19:23 -0700, Cristian Cudizio wrote:

> one session with one V$lock record type 'TX' and lmode=6 and the others
> with lmode=0 and REQUEST=6.
> So, what does it mean that? why a lot of locks with lmode=3? I've tested
> from sql*plus to do
> an update on locked table and my session was waing and in v$lock it was
> with lmode=3.

Lock of the type TX is an exclusive transaction lock. It locks rows. Lock of the type TM is a table lock. It is a shared, row exclusive lock of type 3 (Shared-ROW-Exclusive. LMODE=0 means that the transaction isn't holding any locks. REQUEST=6 means that the transaction is requesting an exclusive lock. Concepts manual and reference manual (for V$LOCK) should have more information.

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