Oracle Cloud Infrastructure Documentation

Automatic Workload Repository (AWR) Report

To download an AWR report, identify the database version and follow the respective steps.

Open the Performance Hub page from the database details page, if not already open.

Note

For more information about how to navigate to the Performance Hub page, see:

For Oracle Database 18c and older

  1. Click the Reports button in the upper-right corner and select Automatic Workload Repository. It opens the Generate Automatic Workload Repository dialog box.

    You can generate a report either from two snapshots close to the current date and time or from a custom time range of your choice.

    To generate a report from a custom time range, select Custom and then select the start and end time for the range.

  2. Click Download to download the AWR report.

Oracle Database generates a report in the format AWRReport_date_range.html for the selected time range.

For Oracle Database 19c and later

  1. In the Quick Select menu, select a time period for the AWR report.

  2. Click the Reports button in the upper-right corner and select Automatic Workload Repository. It opens the Generate Automatic Workload Repository dialog box.

  3. Select the begin time of the snapshot from Start Snapshot and the end time from End Snapshot.

    You can also get information about a specific instance and monitor its performance. This option is not enabled by default. To include details of a particular instance in the AWR report, click the check box Instance Level Report and select the instance from the drop-down list.

    Note

    Currently, this feature is supported for Base Database Service and External Database.

  4. Click Download to generate the report and download it.

Oracle Database generates the report in the format AWRReport_date_range.html for the selected time range. When the report is complete, the report name is displayed at the top of the screen, and the report is downloaded automatically.