How to create manualy the AWR reports

Not everyone has a GUI to extract the AWR reports from an Oracle database, hence here is what you need to do:

SCOTT@DB_TEST> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

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

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 3621956494 DB_TEST              1 DB_TEST

Elapsed: 00:00:00.03
Elapsed: 00:00:00.01

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

Type Specified:                  text
Elapsed: 00:00:00.02


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

   DB Id     Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
* 2121932494        1 DB_TEST       DB_TEST       NODE1

Using 3621956494 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
------------ ------------ --------- ------------------ -----
DB_TEST       DB_TEST         64869 05 Nov 2015 00:00      1
                              64870 05 Nov 2015 01:00      1
                              64871 05 Nov 2015 02:00      1
                              64872 05 Nov 2015 03:00      1
                              64873 05 Nov 2015 04:00      1
                              64874 05 Nov 2015 05:00      1
                              64875 05 Nov 2015 06:00      1
                              64876 05 Nov 2015 07:00      1
                              64877 05 Nov 2015 08:00      1
                              64878 05 Nov 2015 09:00      1
                              64879 05 Nov 2015 10:00      1



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

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



Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_64878_64879.txt.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name:

Have fun!!

Advertisements