生成oracle 10G的AWR报告

上一篇 / 下一篇  2010-10-28 09:59:27 / 个人分类:Oracle

使用Oracle用户登录,打开终端出现$提示符。

$

 

使用Sqlplus连接Oracle实例(SID_NAME用实际实例名称替换)

$ORACLE_SID=SID_NAME

$export ORACLE_SID

$sqlplus / as sysdba

SQL>

 

运行$ORACLE_HOME/rdbms/admin/awrrpt.sql脚本,产生AWR报告。

SQL>@?/rdbms/admin/awrrpt.sql

 

Current Instance

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

 

  DB Id   DB Name     Inst Num Instance

----------- ------------ -------- ------------

 2474782443 MOON               1 MOON

 

 

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'

输入报告文件类型(html或者text

Enter value for report_type:html

 

Type Specified:                 html

 

 

Instances in this Workload Repository schema

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

 

  DB Id    Inst Num DB Name     Instance    Host

------------ -------- ------------ ------------ ------------

* 2474782443       1 MOON        MOON        racdb2

 

Using 2474782443 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.

 

输入需要收集几天内的AWR信息

Enter value for num_days:7

 

Listing the last day's Completed Snapshots

 

                                                       Snap

Instance    DB Name       Snap Id   Snap Started   Level

------------ ------------ --------- ------------------ -----

MOON        MOON               54 17 62010 09:3    1

                                   9

                                55 17 62010 11:0    1

                                   0

                                56 17 62010 12:0    1

                                   0

                                57 17 62010 13:0    1

                                   0

 

                                58 17 62010 16:5    1

                                   0

                                59 17 62010 18:0    1

                                   0

 

 

 

Specify the Begin and End Snapshot Ids

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

根据以上列出的快照号(SNAP ID)和快照时间,选择需要的分析的快照信息(begin_snapend_snap

Enter value for begin_snap:54

Begin Snapshot Id specified: 54

 

选择结束快照号

Enter value for end_snap:57

End  Snapshot Id specified: 57

 

 

Specify the Report Name

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

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

press <return> to continue, otherwise enter an alternative.

 

输入生成报告的文件名称

Enter value for report_name:?/awrrpt.html

 

…..

退出sqlplus,回到$提示符。

SQL>exit

$

生成的文件位于$ORACLE_HOME目录

$cd $ORACLE_HOME

$ls –l awrrpt.html

 

使用ftp或者sftp工具将该文件下载到本地硬盘,进行分析。


TAG:

 

评分:0

我来说两句

Open Toolbar