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: AQ, RAC and delay

Re: AQ, RAC and delay

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 19 Jun 2003 05:35:02 -0700
Message-ID: <F001.005B4C1F.20030619043743@fatcity.com>



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 com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
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: [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 - 07:35:02 CDT

Original text of this message

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