oracle10g生成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 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: 2Begin Snapshot Id specified: 2

Enter value for end_snap: 9End   Snapshot Id specified: 9

Specify the Report Name

~~~~~~~~~~~~~~~~~~~~~~~

The default report file name is awrrpt_1_2_9.html.  To use this name,

press to continue, otherwise enter an alternative.

“输出分析报告文件”

Enter value for report_name: /opt/awrrpt.html

posted on 2010-10-20 09:55 cssseek 阅读(1891) 评论(1)  编辑  收藏 所属分类: 数据库