Not everyone has a GUI to extract the AWR reports from an Oracle database, hence here is what you need to do:
[email protected]_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!!
