Re: max_commit_propagation_delay

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" <ORACLE-L_at_fatcity.com> 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: jonathan_at_jlcomp.demon.co.uk

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: ListGuru_at_fatcity.com (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).