Oracle Awr Report Extraction method

This article is intended to instruct project personnel to extract the AWR reports of Oracle databases themselves.

1. The AWR report extraction for the current connection instance: @?/rdbms/admin/awrrpt

Other instances of 2.RAC AWR report extract: @?/rdbms/admin/awrrpti

3. Manually generate a Snapshot

1. The AWR report extraction for the current connection instance: @?/rdbms/admin/awrrpt

Sql> @?/rdbms/admin/awrrpt//Note that there is no space in the middle of the input @?/rdbms/admin/awrrpt, you need to log on to the Oracle user on the database server, Sqlplus/as SYSDBA into SQL > Under execution.
Current instance~~~~~~~~~~~~~~~~ DB Id db Name Inst Num Instance-------------------------------------------  857123342 JY 1 jy1specify the report type~~~~~~~~~~~~~~~~~~~~~~~would a HTML report, or a plain Text report? Enter ' HTML ' for the HTML report, or ' text ' for plain textdefaults to ' HTML ' Enter the value for Report_type://Note here the direct carriage return, the default is H tml format Type specified:htmlinstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB I         D Inst Num DB Name Instance Host--------------------------------------------------------857123342 2 JY jy2 rac2-server* 857123342 1 jy jy1 rac1-serverusing 857123342 for Database Idusing 1 For instance numberspecify the number of days of snapshots to choose from~~~~~~~~~~~~~~~~~~~~~  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~entering the number of days (n) would result in the most recent (n) days of snapshots being  Listed. PRessing <return> withoutspecifying A number lists all completed snapshots. Enter value for num_days:1//note here, depending on the actual need to select a few days of the AWR report, generally take the latest AWR report select 1 days to
Listing the last day ' s completed snapshots snapinstance DB Name                  Snap Id snap Started level--------------------------------------------------------jy1 JY                                 1 Oct 07:32 2014 09:00 1 94 Oct 1 10:00AM-Oct 1Specify the Begin and End Snapshot ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~enter value for Begin_snap:94begin Snapshot Id specified:94enter Value for End_snap:95end Snapshot Id specified:95//Note that the begin_snap  and  end_snap entered here are actual snap  based on the specific time points above ID that column decided .  such as I want to choose 09:00-10:00 words, that start should be 93 and 94. specify the report name~~~~~~~~~~~~~~~~~~~~~~~the default  Report file name is awrrpt_1_94_95.html. To the name,press <return> to continue, otherwise enter an alternative. Enter value for Report_name://Here The default carriage return isBut the name will have a default value. 
Using the report name awrrpt_1_94_95.html
A large number of screen outputs are omitted here:
End of Report</body>
Note: The generated report file is sent to me, for example, here is the awrrpt_1_94_95.html file, which represents the workload report of the DB instance jy1 for the hour of October 16, 2014 10 o'clock.
Other instances of 2.RAC AWR report extract: @?/rdbms/admin/awrrpti
Sql> @?/rdbms/admin/awrrptispecify the report type~~~~~~~~~~~~~~~~~~~~~~~would a HTML report, or a plain text Report? Enter ' HTML ' for the HTML report, or ' text ' for plain textdefaults to ' HTML ' enter value for Report_type:type specified:h      Tmlinstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num db Name          Instance Host--------------------------------------------------------857123342 2 JY jy2 rac2-server* 857123342 1 JY jy1 rac1-serverenter value for dbid:857123342using 85712334 2 for database Identer value for inst_num:2using 2 for instance numberspecify the number of days of snapshots to choose F Rom~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~entering the number of days (n) would result in the most recent (n  ) Days of snapshots being listed. Pressing <return> withoutspecifying A number lists all completed snapshots. Enter value for Num_dayS:listing all completed snapshots snapinstance DB Name                  Snap Id snap Started level--------------------------------------------------------jy2 JY                                 10:10 1 Oct 2014 07:32 1 1 94 Oct 2014 10:00 1 9 5 Oct 1 Specify the Begin and End Snapshot ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~enter value for Beg  In_snap:94begin Snapshot ID specified:94enter value for end_snap:95 end Snapshot ID specified:95 Specify  Name~~~~~~~~~~~~~~~~~~~~~~~the default report, file name is awrrpt_2_94_95.html. To the name,press <return> to continue, otherwise enter an alternative. Enter value for report_name:using the report name awrrpt_2_94_95.html here to omit a large number of screen outputs: End of Report</body>3. Manually generate a snapshot:
exec dbms_workload_repository.create_snapshot ();
Sql> exec dbms_workload_repository.create_snapshot ();P L/sql procedure successfully completed.
Oracle Awr Report Extraction method