Топ-100
 
CerebroSQL

AWR report generator

Free download

The Automatic Workload Repository is a set of internal Oracle database data 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.

Show AWR report from Oracle.jpg
Opening a window
  • Main program window - Action Menu - AWR

  • Query Editor - Management Menu - Create AWR

Generating a report
  • From the Start_id drop-down list, select the snapshot ID from which to generate the report

  • From the End_id drop-down list, select the snapshot ID ending with which to generate the report

  • Press the Show button

-> Request to retrieve data <-

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 (CoreDB.db base)

View a previously saved report

Select the report you are interested in in the List AWR list

Compare reports

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

Compare AWR.jpg