Re: Oracle RAC and AWR

From: Bob Jones <email_at_me.not>
Date: Fri, 06 Oct 2006 00:41:20 GMT
Message-ID: <QChVg.9314$vJ2.7073@newssvr12.news.prodigy.com>

"BCB" <bdcbuning_at_freeit.nl> wrote in message news:1160070315.492504.223630_at_m73g2000cwd.googlegroups.com...
>
> wagen123_at_yahoo.com schreef:
>
>> 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.
>>
>> wagen
>
> Hello,
>
> In Oracle 10.2 grid there is no way to get everything together in one
> report. This is not possible.
> But there is good news, in the Oracle 11g release there will be a
> global part, I expect but can not confirm that this will provide the
> functionality you are looking for.
>

An even better news, 12g will be self-tuned and you will not need to perform such action. Just need to wait a few years or so. Received on Thu Oct 05 2006 - 19:41:20 CDT