AWR Reports

The AWR stands for Automated Workload Repository Report and provides a set of tables into which snapshots of system statistics are stored. Generally, these snapshots are taken on an hourly basis and include wait interface statistics, top SQL, memory, and I/O information that is cumulative in nature up to the time of the capture.

The AWR report process takes the cumulative data from two snapshots and subtracts the earlier snapshot’s cumulative data from the later snapshot and then generates a delta report showing the statistics and information relevant for the time period requested.

Search Generated AWR Reports

Search Generated AWR Reports screen can be accessed by a ‘Viewer’ having RDS_MANAGEMENT_VIEWER or RDS_MANAGEMENT_VIEWER_PREPROD roles and shows a list of generated reports and also allows the user to filter the reports based on the following:

  • Snap ID – The unique key of a snapshot

  • Generated By – System or User

  • Interval by Date and Hour

Figure 4-30 AWR Reports


AWR Reports

The list of generated report logs are listed in the “AWR Generated Report Logs” table that contains the following information for every Report ID. The ‘Refresh Report Logs’ button can be used to refresh the table to display the newly generated reports.

  • Report ID: Unique ID of the generated report.

  • Start Snap ID: Snap ID of the start snapshot in that time interval.

  • End Snap ID: Snap ID of the end snapshot in that time interval.

  • Start Interval: Start timestamp of the snapshot interval.

  • End Interval: End timestamp of the snapshot interval.

  • Generated By: If generated automatically by the system, then SYSTEM is populated. If generated manually by any user, then that user’s ID is populated.

  • Generated Date and Time: Timestamp of the report generation.

  • Allow Delete: Indicator that mentions if the report can be deleted or not.

AWR Report Viewer

When clicking on the Report ID, a detailed AWR Report is displayed. The report can be downloaded or deleted from this window.

Figure 4-31 AWR Report Viewer


AWR Report Viewer

Generate AWR Custom Reports

This screen enables an ‘Owner’ having RDS_MANAGEMENT_OWNER or RDS_MANAGEMENT_OWNER_PREPROD roles to generate reports based on Interval Start Date and Time and Interval by Number of Hours.

Figure 4-32 AWR Reports Generation


AWR Reports Generation