@H_502_0@How to generate an AWR report.
@H_502_0@
@H_502_0@1. $ export ORACLE_SID=batch005
@H_502_0@2. $ echo $ORACLE_SID
@H_502_0@3. $ sqlplus / as sysdba
@H_502_0@4. sql> @$ORACLE_HOME/rdbms/admin/awrrpt.sql
@H_502_0@
@H_502_0@Current Instance
@H_502_0@~~~~~~~~~~~~~~~~
@H_502_0@
@H_502_0@ DB Id DB Name Inst Num Instance
@H_502_0@----------- ------------ -------- ------------
@H_502_0@ 853510723 BATCH005 1 batch005
@H_502_0@
@H_502_0@
@H_502_0@Specify the Report Type
@H_502_0@~~~~~~~~~~~~~~~~~~~~~~~
@H_502_0@Would you like an HTML report,or a plain text report?
@H_502_0@Enter 'html' for an HTML report,or 'text' for plain text
@H_502_0@Defaults to 'html'
@H_502_0@Enter value for report_type: html
@H_502_0@
@H_502_0@Type Specified: html
@H_502_0@
@H_502_0@EXT
@H_502_0@-----
@H_502_0@.html
@H_502_0@
@H_502_0@
@H_502_0@Instances in this Workload Repository schema
@H_502_0@~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@H_502_0@
@H_502_0@ DB Id Inst Num DB Name Instance Host
@H_502_0@------------ -------- ------------ ------------ ------------
@H_502_0@* 853510723 1 BATCH005 batch005 XXX.com
@H_502_0@
@H_502_0@Using 853510723 for database Id
@H_502_0@Using 1 for instance number
@H_502_0@
@H_502_0@
@H_502_0@Specify the number of days of snapshots to choose from
@H_502_0@~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@H_502_0@Entering the number of days (n) will result in the most recent
@H_502_0@(n) days of snapshots being listed. Pressing <return> without
@H_502_0@specifying a number lists all completed snapshots.
@H_502_0@
@H_502_0@
@H_502_0@Enter value for num_days: 2 # show latest 2-days snapshot
@H_502_0@
@H_502_0@Listing the last 2 days of Completed Snapshots
@H_502_0@
@H_502_0@ Snap
@H_502_0@Instance DB Name Snap Id Snap Started Level
@H_502_0@------------ ------------ --------- ------------------ -----
@H_502_0@batch005 BATCH005 7681 09 Jun 2015 00:00 1
@H_502_0@ 7682 09 Jun 2015 01:00 1
@H_502_0@ 7683 09 Jun 2015 02:00 1
@H_502_0@ 7684 09 Jun 2015 03:01 1
@H_502_0@ 7685 09 Jun 2015 04:00 1
@H_502_0@ 7686 09 Jun 2015 05:00 1
@H_502_0@ 7687 09 Jun 2015 06:00 1
@H_502_0@ 7688 09 Jun 2015 07:00 1
@H_502_0@ 7689 09 Jun 2015 08:00 1
@H_502_0@ 7690 09 Jun 2015 09:00 1
@H_502_0@ 7691 09 Jun 2015 10:00 1
@H_502_0@ 7692 09 Jun 2015 11:00 1
@H_502_0@ 7693 09 Jun 2015 12:00 1
@H_502_0@ 7694 09 Jun 2015 13:00 1
@H_502_0@ 7695 09 Jun 2015 14:00 1
@H_502_0@ 7696 09 Jun 2015 15:00 1
@H_502_0@ 7697 09 Jun 2015 16:00 1
@H_502_0@ 7698 09 Jun 2015 17:00 1
@H_502_0@ 7699 09 Jun 2015 18:01 1
@H_502_0@ 7700 09 Jun 2015 19:00 1
@H_502_0@ 7701 09 Jun 2015 20:00 1
@H_502_0@ 7702 09 Jun 2015 21:00 1
@H_502_0@ 7703 09 Jun 2015 22:00 1
@H_502_0@ 7704 09 Jun 2015 23:00 1
@H_502_0@ 7705 10 Jun 2015 00:00 1
@H_502_0@ 7706 10 Jun 2015 01:00 1
@H_502_0@
@H_502_0@
@H_502_0@
@H_502_0@Specify the Begin and End Snapshot Ids
@H_502_0@~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
@H_502_0@Enter value for begin_snap: 7705 #show the last snapshot
@H_502_0@Begin Snapshot Id specified: 7705
@H_502_0@
@H_502_0@Enter value for end_snap: 7706 #show the last snapshot
@H_502_0@End Snapshot Id specified: 7706
@H_502_0@
@H_502_0@
@H_502_0@
@H_502_0@Specify the Report Name
@H_502_0@~~~~~~~~~~~~~~~~~~~~~~~
@H_502_0@The default report file name is awrrpt_1_7705_7706.html. To use this name,
@H_502_0@press <return> to continue,otherwise enter an alternative.
@H_502_0@
@H_502_0@Enter value for report_name:
@H_502_0@
@H_502_0@Using the report name awrrpt_1_7705_7706.html
@H_502_0@
@H_502_0@sql> quit
@H_502_0@
@H_502_0@
@H_502_0@Here,AWR report awrrpt_1_7705_7706.html is generated.
@H_502_0@
@H_502_0@
@H_502_0@Next step: How to read an AWR report ?
@H_502_0@Refer to: http://oraclewindow.blogspot.jp/2013/05/how-to-read-awr-reports.html
