Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RAC setting for max consistency?

Re: RAC setting for max consistency?

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Mon, 17 Sep 2007 07:25:10 -0700
Message-ID: <1190039110.662753.4990@19g2000hsx.googlegroups.com>


Sybrand,

Max Commit Propagation Delay (MCPD) tells which algorithm to choose to propagate commits in a RAC environment. When you set it to default (10.1 and earlier) 700 cs , it uses lamport algorithm for SCN propagation. Setting this to lower values enables the Broadcast on Commit (BOC) which is little bit more expensive on messages, but commits are visible immediately to the other nodes.

In current versions (10.2 and above) the BOC algorithms are optimized and is the default SCN propagation mechanism. Check the following URL for an exceprt from my RAC Book..

http://searchsystemschannel.techtarget.com/generic/0,295582,sid99_gci1254261,00.html

-Gopal Received on Mon Sep 17 2007 - 09:25:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US