RE: "wait for scn from all nodes" wait in RAC

From: Cary Millsap <Cary.Millsap_at_hotsos.com>
Date: Fri, 15 Jul 2005 15:46:45 -0500
Message-ID: <2110.73841121460311.hotsos01.hotsos.com@MHS>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hameed, Amir
Sent: Friday, July 15, 2005 3:14 PM
To: oracle-l_at_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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 15 2005 - 15:48:56 CDT