Generate an AWR Report

An AWR report contains performance statistics on database activity between two points in time – two snapshots. This can be used for problem detection and self-tuning purposes. For example, you can compare database statistics captured during a period of poor performance and compare it with normal baseline performance to identify and diagnose problems. Because AWR Hub stores AWR snapshots for multiple databases, you can easily compare performance statistics across your database fleet.

Typical Use Cases

• Track and analyze SQL plan changes for workloads within a single database
• Track and analyze SQL plan changes for workloads across multiple databases
• Understand past and present workload (SQL) performance over a period of two years or above.
• Build custom dashboards to plot SQL performance statistics, database waits, CPU usage history, connections established, etc.

Create an AWR Report

1. On accessing AWR Hub, click the Actions menu for a database, and then select Generate AWR report.
2. In the Generate Automatic Workload Repository report panel, select a Snapshot start time (UTC).

   The date entered is used to query snapshots in the 24-hour time range following that date, and the AWR report is restricted to a one-day range. The available snapshots are then listed in Start snapshot and End snapshot.

3. Select snapshots in Start snapshot and End snapshot.
4. Click Download to generate the report in HTML format.