首页 > 数据库 > 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

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

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


  • 博文量
  • 访问量