Re: Oracle RAC and AWR

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 5 Oct 2006 08:06:12 -0700
Message-ID: <1160060772.418549.267600@m7g2000cwm.googlegroups.com>

wagen123_at_yahoo.com wrote:
> Oracle10g 10.2.0.2 (64 bit)
> RHEL AS 4.3 (64 bit)
> 4 Node RAC cluster
>
> We execute AWR snapshots every 15 minutes during stress/load testing in
> our QA environment. To identify the resource intensive SQL's currently
> I have to look into each AWR report generated on EACH node of the RAC
> cluster.
>
> Is there any way to get a consolidated view across all nodes of the RAC
> cluster? I tried 10g Grid Control, couldn't find a way out.
>
> Thanks for any help/pointers.

A snapshot is done on an instance level basis. Received on Thu Oct 05 2006 - 10:06:12 CDT