Home » Server Options » RAC & Failsafe » parameter max_commit_propogation_delay in RAC env.
parameter max_commit_propogation_delay in RAC env. [message #136557] Thu, 08 September 2005 13:35 Go to next message
ashishsinghal77
Messages: 9
Registered: August 2005
Junior Member
Hi,

I am using 2 instance in rac env. and updating data in 1 instance and reading the same data in other instance, after the commit also for sometimes changes are not visible immediately into the 2'nd instance, can i use max_commit_propogation_delay parameter to see the immediate effect of commit, by setting this parameter value to 0.

i want to know what are the effects of setting this parameter value to 0. and by setting this parameter value to 0 will i be able to resolve the problem..


Ashish
Re: parameter max_commit_propogation_delay in RAC env. [message #136933 is a reply to message #136557] Mon, 12 September 2005 06:02 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Yes, however setting MAX_COMMIT_PROPOGATION_DELAY=0 will add some overhead as LGWR will have to send messages to notify other instances of every COMMIT.

Also, note the following bug in 9.2.0.4 - OERI:KJUHL1 can occur when MAX_COMMIT_PROPOGATION_DELAY <=700

Best regards.

Frank
Re: parameter max_commit_propogation_delay in RAC env. [message #137163 is a reply to message #136933] Tue, 13 September 2005 08:54 Go to previous messageGo to next message
ashishsinghal77
Messages: 9
Registered: August 2005
Junior Member
Hi Frank,

Thanx for ut response..

i set the parameter max_commit_popogation_delay = 0, bt then also my queries are not syncronized,

like we have 2 nodes, and in 1 nodes we are updating 1 table and immediatly after commit we are reading the same data from the 2'nd node but the changes are nt vivible in the second node..

can u please advise me what i can do in this situation..


Regards

Ashish
Re: parameter max_commit_propogation_delay in RAC env. [message #137196 is a reply to message #137163] Tue, 13 September 2005 13:35 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Have you set this parameter on all instances, and restarted them all?

Best regards.

Frank
Re: parameter max_commit_propogation_delay in RAC env. [message #137311 is a reply to message #137196] Wed, 14 September 2005 08:40 Go to previous message
ashishsinghal77
Messages: 9
Registered: August 2005
Junior Member
Yes I setted this parameter in all the instances and restart all the instances..

Ashish
Previous Topic: Number of connected users to RAC system
Next Topic: behavior in RAC failover
Goto Forum:
  


Current Time: Fri Mar 29 02:45:12 CDT 2024