I need a AWR report for a RAC database. What
is the AWR report script that is used to create a AWR report
for all instances on a RAC database?
awrrpti.sql report is used to report against a RAC database.
Unlike the standard RAC report (awrrpt.sql), this script
will allow you to define the instance you want to report on.
Thus AWR allows instance specific reporting in a RAC
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.