AWR report types
@?/rdbms/admin/awrrpt.sql -- basic AWR report
@?/rdbms/admin/awrsqrpt.sql -- Standard SQL statement Report
@?/rdbms/admin/awrddrpt.sql -- Period diff on current instance
@?/rdbms/admin/awrrpti.sql -- Workload Repository Report Instance (RAC)
@?/rdbms/admin/awrgrpt.sql -- AWR Global Report (RAC)
@?/rdbms/admin/awrgdrpt.sql -- AWR Global Diff Report (RAC)
@?/rdbms/admin/awrinfo.sql -- Script to output general AWR information
Create an AWR report for a certain test case and display it with firefox
Create an AWR snapshot ,run your test case and after that create a 2nd AWR snapshot
EXECUTE dbms_workload_repository.create_snapshot();
--> run test case:
[oracle@grac41 JDBC]$ java UCPDemo 1000
EXECUTE dbms_workload_repository.create_snapshot();
Create an AWR report
SQL> @?/rdbms/admin/awrgrpt.sql [ @?/rdbms/admin/awrddrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------event_histogram.sql -------- ------------
794109772 GRAC4 1 grac41
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type:
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
794109772 3 GRAC4 grac43 grac43.example.com
* 794109772 1 GRAC4 grac41 grac41.example.com
794109772 2 GRAC4 grac42 grac42.example.com
Using 794109772 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing <return> without
specifying a number lists all completed snapshots.
Enter value for num_days: 1
Listing the last day's Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
grac41 GRAC4 358 29 Oct 2013 11:00 1
..
364 29 Oct 2013 15:04 1
365 29 Oct 2013 15:16 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 364
Begin Snapshot Id specified: 364
Enter value for end_snap: 365
End Snapshot Id specified: 365
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_364_365.html. To use this name,
press <return> to continue, otherwise enter an alternative.
Display the report with firefox
$ firefox awrrpt_1_364_365.html
Nice Article.