Re: v$lock - Blocker

On Mon, Jan 12, 2009 at 3:21 PM, Shivaswamy / ಶಿವಸ್ವಾಮಿ < shivaswamykr_at_gmail.com> wrote:

> Hello.
>
> 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
>

-- 
Mahesh Rajendran
--
http://www.freelists.org/webpage/oracle-l