Configuration of AWR report

AWR Reports (Automatic Workload Repository)
For those who were to lazy to install Statspack - available since 8.1.5 - there is good news assuming you are on 10G and assuming you were also to lazy to modify the init parameter statistics_level (I don' t see until now many reasons to alter the default value of typical ). Since 10.1 there is a built in "super statspack". (statspack is still available). In stead of statspack reports we speak about AWR reports , in stead of statspack snapshots we speak about AWR snapshots. By default AWR s snapshot' s are taken every hour (AWR = Automatic Workload Repository ) Statistical information has been gathered and written to disk, towards the new sysaux tablespace by the new backgroundprocess MMON. ( MMON =Manageability Monitor ). Please note you can also take ADDM Reports
We can still take a snapshot manually
SQL> exec dbms_workload_repository.create_snapshot;
PL/SQL procedure successfully completed.
As well we can change the retention period and the snapshot interval. In the example below we change the retention period to 5 days ( 5 x 24 x 60 ) and the snapshot interval to 30 minutes.
SQL> exec dbms_workload_repository.modify_snapshot_settings (retention => 7200,interval => 30);
PL/SQL procedure successfully completed.
So we should not install anything anymore neither we should schedule jobs. I will show you what there is left to do
SQL> @C:\oracle\10.2.0\rdbms\admin\awrrpt.sql;

Current Instance
~~~~~~~~~~~~~~~~

DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
2144058311 STERIA 1 steria

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

Type Specified:

Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 2144058311 1 STERIA steria Oracle

Using 2144058311 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 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
------------ ------------ --------- ------------------ -----
steria STERIA 6380 10 Oct 2005 00:00 1
6381 10 Oct 2005 01:00 1
6382 10 Oct 2005 02:00 1
6383 10 Oct 2005 03:01 1
6384 10 Oct 2005 04:00 1
6385 10 Oct 2005 05:00 1
6386 10 Oct 2005 06:00 1
6387 10 Oct 2005 07:00 1
6388 10 Oct 2005 08:00 1
6389 10 Oct 2005 09:00 1
6390 10 Oct 2005 10:00 1
6391 10 Oct 2005 11:00 1
6392 10 Oct 2005 12:00 1
6393 10 Oct 2005 13:00 1
6394 10 Oct 2005 14:00 1
6395 10 Oct 2005 15:00 1
6396 10 Oct 2005 16:00 1

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 6394
Begin Snapshot Id specified: 6394

Enter value for end_snap: 6396
End Snapshot Id specified: 6396

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_6394_6396.html. To use this name,
press to continue, otherwise enter an alternative.
That' s it. You can take a look for a sample output
Example output AWR report
Some documentation
Oracle' s Metalink
Doc ID:
Note:276103.1