Re: v$lock - Blocker

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-l


Other related posts: