Home > Workload Solutions > Oracle > White Papers > Deployment Best Practices for Oracle Databases with Dell EMC PowerMax > Appendix V. Oracle AWR I/O related information
Collect AWR reports over peak workload periods to identify any potential bottlenecks. AWR averages all metrics over the duration of the report; therefore a 24-hour report is generally not useful. A useful AWR report is produced for a short period of time, for example, 15 minutes, 30 minutes, or one hour, when the workload is stable and heavy.
When using Oracle RAC, AWR reports can be produced for each instance separately or for the cluster as a whole. The Instance AWR metrics only represent the workload on that specific database server. The RAC AWR metrics represent the workload from the entire cluster. In the following examples, we show both types. Note that with each Oracle release some changes were made to the report.