From oracle-l-bounce@freelists.org Fri Jul 15 15:48:56 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6FKmugw009960 for ; Fri, 15 Jul 2005 15:48:56 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6FKmqIP009947 for ; Fri, 15 Jul 2005 15:48:52 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CDE2E1D19B6; Fri, 15 Jul 2005 15:48:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02317-05; Fri, 15 Jul 2005 15:48:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 416AB1D1990; Fri, 15 Jul 2005 15:48:45 -0500 (EST) Date: Fri, 15 Jul 2005 15:46:45 -0500 From: "Cary Millsap" To: Message-ID: <2110.73841121460311.hotsos01.hotsos.com@MHS> In-Reply-To: <77A4D80DB2ADD74EB5D7F1D31626F0C0020161CD@usa0300ms03.na.xerox.> Subject: RE: "wait for scn from all nodes" wait in RAC x-scalix-Hops: 1 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcWJebRHC7FnOZ/0TfGrHgDqJCFMLQABGL7Q MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_009B_01C58954.67862570" X-archive-position: 22558 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Cary.Millsap@hotsos.com Precedence: normal Reply-To: Cary.Millsap@hotsos.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.3 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_009B_01C58954.67862570 Content-Type: text/plain; charset="US-ASCII" Content-Disposition: inline Amir, Only you can tell us whether the issue is of legitimate concern, right? :-) Is the event a dominant contributor to the response time of an important business task? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Visit www.hotsos.com for curriculum and schedule details... _____ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Hameed, Amir Sent: Friday, July 15, 2005 3:14 PM To: oracle-l@freelists.org Subject: "wait for scn from all nodes" wait in RAC Does anyone know what this wait (wait for scn from all nodes) is about in RAC. We are currently running a test on a two-node RAC/11i instance. Statspack is showing this wait among the top five (at #5). We are using the "broadcast on commit" scheme as it is recommended by Oracle for 11i instances. Per Metalink, this event is related to the broadcast scheme that we are using. But what does it really mean and at what point it becomes a matter of concern? Any feedback will be appreciated. Thank you Amir ------=_NextPart_000_009B_01C58954.67862570 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline "wait for scn from all nodes" wait in RAC

Amir,

 

Only you can tell us whether the issue is of legitimate concern, right? J

 

Is the event a dominant contributor t= o the response time of an important business task?

=

 

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in verba

Visit www.hotsos.com for curriculum= and schedule details...

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] <= span style=3D'font-weight:bold'>On Behalf Of Hameed, Amir
Sent: Friday, July 15, 200= 5 3:14 PM
To: oracle-l@freelists.org=
Subject: "wait for sc= n from all nodes" wait in RAC

 

Does anyone know what this wait (wait for scn from all nodes) is about in RAC. W= e are currently running a test on a two-node RAC/11i instance. Statspack is sho= wing this wait among the top five (at #5). We are using the "broadcast on= commit" scheme as it is recommended by Oracle for 11i instances. Per= Metalink, this event is related to the broadcast scheme that we are using= =2E But what does it really mean and at what point it becomes a matter of concern= ? Any feedback will be appreciated.

Thank you
Amir

------=_NextPart_000_009B_01C58954.67862570-- -- http://www.freelists.org/webpage/oracle-l