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.
For more information about how to navigate to the Performance Hub page, see:
For Oracle Database 18c and older
-
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.
-
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
-
In the Quick Select menu, select a time period for the AWR report.
-
Click the Reports button in the upper-right corner and select Automatic Workload Repository. It opens the Generate Automatic Workload Repository dialog box.
-
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.
-
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.