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
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
