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 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).