Oracle 生成awr报告

--AWR报告（自动工作负载存储库，Automatic Workload Repository）

镜像保存一个月左右

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

Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 1187003854 DBTEST              1 dbtest

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: text

Type Specified:  text

Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
* 1187003854        1 DBTEST       dbtest       serverf

Using 1187003854 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: 2

Listing the last 2 days of Completed Snapshots

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
dbtest       DBTEST               6 22 Sep 2012 09:14      1
                                  7 22 Sep 2012 09:38      1

 

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 6
Begin Snapshot Id specified: 6

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

 

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_6_7.txt.  To use this name,
press to continue, otherwise enter an alternative.

Enter value for report_name: /u01/awrtest.html

Report written to /u01/awrtest.html  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27633655/viewspace-1081554/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27633655/viewspace-1081554/