Home » Server Options » RAC & Failsafe » Action for BLOCK=2 in V$LOCK (Solaris 10/ Oracle Database 10g Enterprise Edition (
Action for BLOCK=2 in V$LOCK [message #477136] Wed, 29 September 2010 00:11 Go to next message
Messages: 165
Registered: July 2006
Location: Chennai
Senior Member
Hi All,

I understand that value of block, if it is 1= block. 2 means it is a global lock in an RAC. I went through some documents but unable to understand. In our environment (RAC), most of the block values are 2.

Not sure, if we can ignore it. Or is it something we need to do about it? Can some please explain me with examples?

Re: Action for BLOCK=2 in V$LOCK [message #477139 is a reply to message #477136] Wed, 29 September 2010 00:39 Go to previous message
Michel Cadot
Messages: 68258
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I went through some documents but unable to understand

It would be interesting you posted us which ones, we may understand them.

You have no more to care than block=1 in exclusive (non-RAC) instance.

Isn't this a RAC question?


[Updated on: Wed, 29 September 2010 00:39]

Report message to a moderator

Previous Topic: adding/extending datafile for tablespace
Next Topic: Patch for Oracle 11gR2 RAC Cluster
Goto Forum:

Current Time: Sat Aug 13 07:31:48 CDT 2022