@awrrpt : current Instance
@awrrpti : for any instance
@awrgrpt.sql : aggregated statistics from all the instances
@awrgdrpt.sql : Global Cluster Difference
@awrsqrpt.sql : Single Select Statement
1. To create one AWR report per instance, for the last snap duration : awrrpt_all_gen.sql
2. Same as (1) but in html format : awrrpt_all_genhtml.sql
3. To create one AWR report per instance, for a range of snap IDs : awrrpt_all_range_gen.sql
4. To create one AWR report, per instance, per snap ID : awrrpt_all_multi_gen.sql
@awrrpti : for any instance
@awrgrpt.sql : aggregated statistics from all the instances
@awrgdrpt.sql : Global Cluster Difference
@awrsqrpt.sql : Single Select Statement
1. To create one AWR report per instance, for the last snap duration : awrrpt_all_gen.sql
2. Same as (1) but in html format : awrrpt_all_genhtml.sql
3. To create one AWR report per instance, for a range of snap IDs : awrrpt_all_range_gen.sql
4. To create one AWR report, per instance, per snap ID : awrrpt_all_multi_gen.sql