Re: v$lock - Blocker
From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 13 Jan 2009 08:30:03 -0800 (PST)
Message-ID: <993088.30517.qm_at_web80605.mail.mud.yahoo.com>
Are you running RAC? If so, see
http://yong321.freeshell.org/oranotes/BlockingSessionInRAC.txt
Date: Tue, 13 Jan 2009 08:30:03 -0800 (PST)
Message-ID: <993088.30517.qm_at_web80605.mail.mud.yahoo.com>
Are you running RAC? If so, see
http://yong321.freeshell.org/oranotes/BlockingSessionInRAC.txt
"In RAC, this value 2 means not more
than that the session is not waiting to get a lock; it could be blocking others or not blocking,
but it's not requesting."
Yong Huang
> I find this odd on v$lock.
>
> My version is 10.2.0.3.0.
> As per the 10.2.0.3 documentation, v$lock.block has A value of either 0 or
> 1, depending on whether or not the lock in question is the blocker.
>
> But, I find
>
> select distinct block from v$lock ;
>
> BLOCK
> ------
> 1
> 2
> 0
>
> Any ideas?
>
> Thanks,
> Shiva
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 13 2009 - 10:30:03 CST