Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: AQ, RAC and delay
I haven't tried with mcpd=0 yet ...
Raj
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 19, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: AQ, RAC and delay
With MPCD=0, Is your primary wait event shown as "on-going reading of SCN to complete" in the statspack reports? Oracle Support insisted we set it to 7 coz of this.
Raj
"K
Gopalakrishnan To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
" cc:
<[EMAIL PROTECTED] Subject: RE: AQ, RAC and delay
o.com>
Sent by:
[EMAIL PROTECTED]
ity.com
06/19/2003
10:29 AM
Please respond
to ORACLE-L
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-----
Hemant K Chitale
Sent: Thursday, June 19, 2003 5:38 AM
To: Multiple recipients of list ORACLE-L
Although 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 !
Hemant
At 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 comAll Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
Hemant K Chitale
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). ********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2Received on Thu Jun 19 2003 - 12:03:29 CDT