oracle手工收集awr报告_oracle 收集AWR报告

SQL>@?/rdbms/admin/awrrpt.sql [会被解析为$ORACLE_HOME]

Current Instance

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

DB id       DB Name                 Inst Num   Instance

588460999 PTLDB                      1               ptldb

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文件]

Specify the number of days of snapsshots 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:1  [系统列出1天内的报告列表]

Enter value for num_days:1

Listing the last day's Completed Snapshots

Instance    DB  Name            Snap Id               Snap Started          Snap Level

ptldb              PTLDB                7236                28 Dec 2010 00:00      1

7258　　　　    28 Dec 2010 21:25      1

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

Enter value for begin_snap:7236[输入起始的快照，性能测试之前产生的]

Enter value for end_snap:7258[输入结束的快照，性能测试之后产生的]

Specify the Report Name

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

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

press to continue,otherwise enter an alternative.

Enter value fro report_name:/home/oracle/awrrpt_1_7236_7258.html [输入报告文件名]

End of Report