Jonathan Lewis
Thu, 27 Mar 2003 10:15:09 -0800
I think Bjørn's answer is the smart one. If you feel very strongly that you need to be able to update at one node and instantly query at another, then you have a strong argument for setting the parameter to zero.
If it is just a 'warm and fuzzy' (a bit like the issue of NOCACHE sequences) then set it to zero, then watch out for indications that the performance is suffering as a consequence. It's certainly something I want to experiment with on 2-node and around 8-node RAC, to measure the impact of zero, 5 - 25, and the default. (My hunch is that a small setting will be more than adequate for most people, and eliminate the worst excesses of a zero setting - but the key word there is HUNCH). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk For one-day tutorials: (see http://www.jlcomp.demon.co.uk/tutorial.html ) ____UK_______April 8th ____UK_______April 22nd ____Denmark May 21-23rd ____USA_(FL)_May 2nd Next dates for the 3-day seminar: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____UK_(Manchester)_May ____Estonia___June (provisional) ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: 27 March 2003 15:29 > > Jonathan, > > Would you recommend setting max_commit_propagation_delay to 0 in 9i2RAC ? > I am considering that for my 2-node instance. > > Hemant > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).