oracle@xxxx01a:/oracle/app/product/11g/db/rdbms/admin> sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 – Production on Thu Sep 5 14:36:04 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> @awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
———– ———— ——– ————
4154300084 ORA11G 1 ora11g
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
———— ——– ———— ———— ————
4154300084 1 ORA11G ora11g xxxxx01b
* 4154300084 1 ORA11G ora11g xxxxx01a
Using 4154300084 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
———— ———— ——— —————— —–
ora11g ORA11G 18146 05 Sep 2013 00:00 1
18147 05 Sep 2013 01:00 1
18148 05 Sep 2013 02:00 1
18149 05 Sep 2013 03:00 1
18150 05 Sep 2013 04:00 1
18151 05 Sep 2013 05:00 1
18152 05 Sep 2013 06:00 1
18153 05 Sep 2013 07:00 1
18154 05 Sep 2013 08:00 1
18155 05 Sep 2013 09:00 1
18156 05 Sep 2013 10:00 1
18157 05 Sep 2013 11:00 1
18158 05 Sep 2013 12:00 1
18159 05 Sep 2013 13:00 1
18160 05 Sep 2013 14:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 18159
Begin Snapshot Id specified: 18159
Enter value for end_snap: 18160
End Snapshot Id specified: 18160
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_18159_18160.html. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name: /home/oracle/testxxx.html
