Re: v$lock - Blocker
Date: Tue, 13 Jan 2009 08:30:03 -0800 (PST)
Are you running RAC? If so, see
"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."
> 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 ;
> Any ideas?