Oracle AWR日志使用

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

 

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 的值:  

Type Specified:  html

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.

输入 num_days 的值:  1

Listing the last day's Completed Snapshots

                                                        Snap

Instance     DB Name        Snap Id    Snap Started    Level

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

orcl10g      ORCL10G            142 03 7月  2009 08:11     1

                                143 03 7月  2009 09:00     1

                                144 03 7月  2009 10:00     1

                                145 03 7月  2009 11:00     1

                                146 03 7月  2009 12:01     1

Specify the Begin and End Snapshot Ids

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

输入 begin_snap 的值:  142

Begin Snapshot Id specified: 142

输入 end_snap 的值:  146

End   Snapshot Id specified: 146

Specify the Report Name

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

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

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

输入 report_name 的值:  /home/Oracle/awrrpt_1_142_146.html

Report written to /home/oracle/awrrpt_1_142_146.html