oracle遇到性能问题时，性能分析的一个思路就是导出AWR分析报告，通过报告分析定位问题根源，以下是oracle10g如何生成分析报告的步骤，oracle10g AWR分析报告文件类型分为txt和html两种，本人习惯使用html。
[root@linux5 /]# su - oracle
[oracle@linux5 ~]$ export ORACLE_SID=orcl
[oracle@linux5 ~]$ cd $ORACLE_HOME/rdbms/admin
[oracle@linux5 admin]$ sqlplus /nolog
SQL> conn /as sysdba
Connected.
SQL> @awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1260101618 ORCL 1 orcl
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: html “选择报告输出的文件类型”
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 1260101618 1 ORCL orcl linux5
Using 1260101618 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: 3 “报告输出的时间范围选择”
Listing the last 3 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
orcl ORCL 1 13 Oct 2010 23:00 1
2 14 Oct 2010 00:00 1
3 14 Oct 2010 01:00 1
4 14 Oct 2010 02:00 1
5 14 Oct 2010 03:00 1
6 14 Oct 2010 04:00 1
7 14 Oct 2010 05:00 1
8 14 Oct 2010 06:00 1
9 14 Oct 2010 07:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
“选择获取报告的快照范围”
Enter value for begin_snap: 2
Begin Snapshot Id specified: 2
Enter value for end_snap: 9
End Snapshot Id specified: 9
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_2_9.html. To use this name,
press <return> to continue, otherwise enter an alternative.
“输出分析报告文件”
Enter value for report_name: /opt/awrrpt.html
第二篇：产量报告
产量报告
XXXX公司由于季节原因，XXXX年第XXXX季度未生产，1——3月份产量为零。
XXXXXX公司
XXXX年X月X日