$cd ORACLE_HOME
$cd rdbms
$cd admin
$sqlplus /nolog
SQL>connect / as sysdba
SQL>@awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~

DB Id DB Name Inst Num Instance
———– ———— ——– ————
XXXX TEST 1 test

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: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
———— ——– ———— ———— ————
* XXXXX 1 TEST test XXXXXX

Using XXXXX 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
Enter value for num_days: 1
Listing the last day’s Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
test TEST 10401 24 Mar 2010 00:00 1
10402 24 Mar 2010 01:00 1
10403 24 Mar 2010 02:00 1
10404 24 Mar 2010 03:00 1
10405 24 Mar 2010 04:00 1
10406 24 Mar 2010 05:00 1

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

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

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_10405_10406.html. To use this name,
press to continue, otherwise enter an alternative.

Enter value for report_name:awrrpt_1_10405_10406.html

This will generate a report into the current folder with “awrrpt_1_10405_10406.html” name