oracle awr使用方式,ORACLE AWR使用

SQL @?/rdbms/admin/awrrpt.sql Current Instance ~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance ———– ———— ——– ———— 3393548168 XFF 1 xff Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ Would you like an HTML report, or a plai

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

Current Instance

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

DB Id DB Name Inst Num Instance

———– ———— ——– ————

3393548168 XFF 1 xff

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’

输入 report_type 的值: html

Type Specified: html

Instances in this Workload Repository schema

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

DB Id Inst Num DB Name Instance Host

———— ——– ———— ———— ————

* 3393548168 1 XFF xff XIFENFEI-PC

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

输入 num_days 的值: 2[天数]

Listing the last 2 days of Completed Snapshots

Snap

Instance DB Name Snap Id Snap Started Level

———— ———— ——— —————— —–

xff XFF 119 22 4月 2011 21:22 1

120 22 4月 2011 21:40 1

121 22 4月 2011 21:40 1

122 22 4月 2011 22:02 1

123 22 4月 2011 22:30 1

124 22 4月 2011 23:00 1

125 22 4月 2011 23:30 1

126 23 4月 2011 00:00 1

Specify the Begin and End Snapshot Ids

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

输入 begin_snap 的值: 120[起始快照号]

Begin Snapshot Id specified: 120

输入 end_snap 的值: 125[结束快照号]

End Snapshot Id specified: 125

Specify the Report Name

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

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

press to continue, otherwise enter an alternative.

输入 report_name 的值:xifenfei.html[文件名]

[回车执行]

本文原创发布php中文网，转载请注明出处，感谢您的尊重！