Oracle AWR报告生成

Oracle AWR报告生成

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