手工生成的时候，需要确认生成AWR报告的时间范围。一般情况下，设置1-7天就可以了
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 2694191837 1 ORCL ORCL redhat4
Using 2694191837 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
specifying a number lists all completed snapshots.
Enter value for num_days: 2 //指定天数范围
Listing the last 2 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
ORCL ORCL 12 31 Aug 2013 13:05 1
13 31 Aug 2013 14:00 1
14 31 Aug 2013 15:00 1
15 31 Aug 2013 16:00 1
16 31 Aug 2013 17:07 1
17 31 Aug 2013 18:00 1
18 31 Aug 2013 19:00 1
19 31 Aug 2013 20:00 1
20 31 Aug 2013 21:00 1
21 31 Aug 2013 22:00 1
22 31 Aug 2013 23:00 1
23 01 Sep 2013 00:01 1
根据列出的时间范围，输入开始和结束的Snap Id
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 22
Begin Snapshot Id specified: 22
Enter value for end_snap: 23
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_22_23.html. To use this name,
press
Enter value for report_name: //指定报表路径和名称 一般默认就行，就是在当前路径生成awrrpt_1_22_23.html的报表