
AWR report generator
The Automatic Workload Repository is a set of internal Oracle database dictionary tables and a special MMON background process that was introduced in Oracle10g .
Periodically, AWR creates a statistical copy (snapshot) and stores information in tables located in the SYSAUX tablespace. By default, the regular collection period is set to 60 minutes. This value can be reduced to 10 minutes if desired.

Opening a window
Main program window - Action menu - AWR
Query Editor - Management Menu - Create AWR
Create a report
From the Start_id drop-down list, select the ID of the snapshot from which to generate the report
From the End_id drop-down list, select the snapshot ID, ending with which to generate a report
Press the Show button
select *
from table(DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_HTML(
(select dbid from v$database),
1,
<Start_id>,
<End_id>)
)
The generated report will be placed in the tmp folder with the name awrtmp.html , as well as stored in the local database in a table CND$AWR_REPORT (base CoreDB.db)
Viewing a previously saved report
In the List AWR list, select the report of interest
Report Comparison
The program allows you to manually compare two previously generated reports.
-
Generate reports for arbitrary periods
-
In the "List AWR" list, set the radio buttons opposite the generated reports
-
Press the "Compare select" button
