Re: Instance wide AWR report for RAC

There is a report for 10.2 with somewhat less functionality than the 11.2 Global reports. The 10.2 version is available for download from OTN:

http://www.oracle.com/technology/products/manageability/database/tools/spawrrac102.zip

The report has been tested on database 10.2.0.4, I'm not sure if you'll hit any issues in 10.2.0.3.

There are some other useful things on that page:

http://www.oracle.com/technology/products/manageability/database/index.html

I hope this helps.
Kurt

On Thu, Feb 25, 2010 at 11:17 AM, Greg Rahn <greg_at_structureddata.org> wrote:

> In 11.1 the the awrg*.sql (AWR Global) reports were introduced that
> give a side-by-side instance comparison. Unfortunately there really
> isn't anything for 10g.
>
>
> http://download.oracle.com/docs/cd/E11882_01/server.112/e10821/autostat.htm#CHDCFBJC
>
>
> The opinions expressed in this email are my own, and not my company's.

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