<FONT face=Arial color=#0000ff
size=2>Hemant:
<FONT face=Arial color=#0000ff
size=2>
You
are right. 7 seconds is the MAX difference, but the control files are
synced
every
3 seconds during the 'split brain' check. So most of the cases, it is 3
seconds
with
the maximum of 7 seconds subject to the MCPD settings.
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>KG
Best Regards,K Gopalakrishnan
<FONT face=Tahoma
size=2>-----Original Message-----From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Hemant K
ChitaleSent: Thursday, June 19, 2003 5:38 AMTo: Multiple
recipients of list ORACLE-LSubject: Re: AQ, RAC and
delayAlthough MCPD may default to 700centiseconds
[although I have seen a much lower value on 9.2 on Tru64],in most cases,
delays of 7seconds don't occur [and shouldn't be acceptable ?!].I do
have a 9iRAC environment but am comfortably using mcpd=0.And I have AQ in an
8.1.7 single-instance environment.So I can't make any statements about AQ in
OPS/RAC !HemantAt 07:05 AM 17-06-03 -0800, you wrote:
<FONT face="Courier New, Courier"
size=2>A colleague casually mentioned that in RAC, the test to de-queue an AQ
set-up from BOTH instances didn't succeed. The side where we were enqueuing
was able to see queued messages faster than the 'other' side. About 7-8
seconds ... that got me thinking ... is this an effect of MCPD which defaults
to like 7 seconds?Do
you use AQ in RAC and enqueue/dequeue on both nodes? What is your
experience? ps: mcpd -
max commit propagation delay <FONT face="Courier New, Courier"
size=2>TIA Raj
<FONT face="Courier New, Courier"
size=2>--------------------------------------------------------------------------------
Rajendra dot Jamadagni at
nospamespn dot com All
Views expressed in this email are strictly personal. <FONT
face="Courier New, Courier" size=2>QOTD: Any clod can have facts, having an
opinion is an art !
Hemant K ChitaleOracle 9i Database Administrator Certified
ProfessionalMy personal web site is : <A
href="
http://hkchital.tripod.com/"
eudora="autourl">
http://hkchital.tripod.com-- Please see the
official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
Received on Thu Jun 19 2003 - 10:00:08 CDT
