Re: monitor cluster interconnect performance

mike wrote:
> Hi,
> We have a 10g service that is load balanced between 2 RAC nodes. We
> noticed that query runs about 3x slower if the service is load
> balanced on both nodes vs running the service on a single node. We did
> verify that all traffic runs on the private network. On OEM, the GC
> block access latency was within 12 ms and the GC block transfer rate
> was within 30ms.
>
> Are these numbers considered high? What other queries or utilities can
> I use to monitor the performance of the interconnect?
>
> Thanks.

Numbers look very high to me. What version of Oracle (3 decimal places)? Post the DML.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org