ITPub博客

首页 > 数据库 > Oracle > Oracle 生成awr报告

Oracle 生成awr报告

原创 Oracle 作者:j04212 时间:2014-02-14 16:25:32 0 删除 编辑


--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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle 审计 audit
下一篇: Oracle 附加日志
请登录后发表评论 登录
全部评论

注册时间:2012-10-23

  • 博文量
    94
  • 访问量
    249188