| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: AQ, RAC and delay
Since I really don't have any performance issues [2 Nodes, 2CPUs each
@1GHz, 2GB, ES45 Tru64Cluster],
I haven't been runnning StatsPack.
However I just ran two snapshots and didn't see such a wait event.
I'm sure that other people have also implemented mcpd=0 successfuly
[my 9iRAC is an Export-Import upgrade from an 8.1.5 OPS environment, where,
too, the earlier DBA had set mcpd=0, with some additional parameters
because of a bug in 8.1.5OPS].
Hemant
At 08:24 AM 19-06-03 -0800, you wrote:
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
[EMAIL PROTECTED]
ity.com
06/19/2003
10:29
Please
to
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 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
-- 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). 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 Fri Jun 20 2003 - 10:15:45 CDT
 |
 |