From kaygopal@yahoo.com Thu, 19 Jun 2003 08:00:08 -0700 From: "K Gopalakrishnan" Date: Thu, 19 Jun 2003 08:00:08 -0700 Subject: RE: AQ, RAC and delay Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hemant:   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.   KG   Best Regards,K Gopalakrishnan -----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: 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 TIA Raj -------------------------------------------------------------------------------- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! Hemant K ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is :  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).