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日