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 On Thu, Feb 25, 2010 at 11:01 AM, Rajesh Rao <Rajesh.Rao@xxxxxxxxxxxx> wrote: > Version 10.2.0.3 > Does Oracle provide a method to generate an AWR that creates a summarized > report for all the instances and is not specific to just a single instance? -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l