Re: v$lock - Blocker
- From: "Mahesh Rajendran" <magvivek@xxxxxxxxx>
- To: shivaswamykr@xxxxxxxxx
- Date: Mon, 12 Jan 2009 15:27:37 -0500
Using RAC?
On Mon, Jan 12, 2009 at 3:21 PM, Shivaswamy / ಶಿವಸ್ವಾಮಿ <
shivaswamykr@xxxxxxxxx> 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
Other related posts: