Home » Server Options » RAC & Failsafe » Action for BLOCK=2 in V$LOCK (Solaris 10/ Oracle Database 10g Enterprise Edition (10.2.0.4))
Action for BLOCK=2 in V$LOCK [message #477136] Wed, 29 September 2010 00:11 Go to next message
jesuisantony
Messages: 116
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?

Regards,
Antony
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: 59145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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?

Regards
Michel

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

Report message to a moderator

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


Current Time: Sat Sep 20 07:37:37 CDT 2014

Total time taken to generate the page: 0.09285 seconds