【练习】手工生成awr报告

最新推荐文章于 2025-09-13 19:07:06 发布

宵蓝

最新推荐文章于 2025-09-13 19:07:06 发布

阅读量62

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/tomatoes-/p/5965128.html

本文详细介绍如何在Oracle环境下以SYSDBA身份登录并使用awrrpt.sql脚本生成AWR报告的过程。从进入指定目录到指定快照ID及报告名称等步骤均有详细指导。

①首先进入$ORACLE_HOME/rdbms/admin目录

[oracle@host02 ~]$ cd $ORACLE_HOME/rdbms/admin

该目录下

[oracle@host02 admin]$ ls -l awrrpt.sql
-rw-r--r-- 1 oracle oinstall 1999 Oct 24  2003 awrrpt.sql

以SYSDBA身份登录运行@awrrpt

SQL>  @awrrpt

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

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
  241462155 ORA11GR2            1 ORA11GR2


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: 

Type Specified:  html


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

   DB Id     Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
* 241462155         1 ORA11GR2     ORA11GR2     host02

Using  241462155 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 <return> without
specifying a number lists all completed snapshots.


Enter value for num_days: 1

Listing the last day's Completed Snapshots

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
ORA11GR2     ORA11GR2            19 15 Oct 2016 18:37      1
                                 20 15 Oct 2016 19:00      1



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

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



Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_19_20.html.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name: 

Using the report name awrrpt_1_19_20.html