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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SCN scheme 3

Re: SCN scheme 3

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 08 Apr 2003 06:54:08 -0800
Message-ID: <F001.0057CC1F.20030408065408@fatcity.com>

On my 9iRAC 9.2.0.2 Database I set max_commit_propagation_delay to 0, yet the alert.log indicates that the Instance is starting with Lamport Server SCN generation. I wonder why.
Hemant
At 12:04 PM 07-04-03 -0800, you wrote:

>Since no-one else has answered, I'll
>take a guess.
>
>Historically OPS used to have two options
>for synchronising SCNs across multiple
>instances, 'broadcast on commit' and 'Lamport'.
>The default was Lamport, but if you modified the
>max_commit_propagation_delay downwards from
>its default value of 700 (centiseconds) then at
>some low value (possibly about 10) the database
>would switch to 'broadcast on commit'.
>
>I guess Oracle have come up with a clever new
>(lazy ?) way of maximising the degree of synchronisation
>whilst minimising the delay at any one instance, and
>called it 'Scheme 3'.
>
>Have you modified the value of max_commit_propagation_delay
>or any other parameter which looks like a timing
>parameter to make this happen ? Or are you on some
>platform with a super-low latency for messaging ?
>
>
>Regards
>
>Jonathan Lewis
>http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
>One-day tutorials:
>http://www.jlcomp.demon.co.uk/tutorial.html
>
>____UK_______April 22nd
>____Denmark__May 21-23rd
>____USA_(FL)_May 2nd
>
>Three-day seminar:
>see http://www.jlcomp.demon.co.uk/seminar.html
>____UK_(Manchester)_May
>____Estonia___June (provisional)
>____Australia_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: 28 March 2003 21:18
>
>
> > List, does anybody know what this means:
> >
> > SCN scheme 3
> >
> > It occurs it the alert log upon startup.
> > thanks,
> >
> > David Ehresmann
> >
>
>
>--
>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).

Hemant K Chitale
My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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).
Received on Tue Apr 08 2003 - 09:54:08 CDT

Original text of this message

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