oracle生成awr报告


1.先获取到两次AWR快照的ID

  SQL> select snap_id from (SELECT * FROM dba_hist_snapshot ORDER BY snap_id desc) where rownum <= 2;

QQ截图20131212161120.jpg

 

2. 进入$ORACLE_HOME/rdbms/admin目录,在sqlplus下运行@awrrpt脚本,按照提示一步一步就可以达成,导出的格式有两种,txt格式和html格式。

[oracle@oraclemaster ~]$ cd $ORACLE_HOME/rdbms/admin
[oracle@oraclemaster admin]$ pwd
/u01/app/oracle/product/11.2.0.1/db_1/rdbms/admin
[oracle@oraclemaster admin]$ sqlplus / as sysdba

SQL>  select snap_id from (SELECT * FROM dba_hist_snapshot ORDER BY snap_id desc) where rownum <= 2;

   SNAP_ID
----------
     12990
     12989

SQL> @awrrpt

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

   DB Id    DB Name  Inst Num Instance
----------- ------------ -------- ------------
 1250833090 DL   1 DL


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

Type Specified:  html


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

   DB Id     Inst Num DB Name    Instance Host
------------ -------- ------------ ------------ ------------
* 1250833090     1 DL    DL  oraclemaster
  1250833090     1 DL    DL  oracleslave

Using 1250833090 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.


输入 num_days 的值:  1

Listing the last day’s Completed Snapshots

       Snap
Instance     DB Name     Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
DL           DL               12974 12 12月 2013 00:00     1
                              12975 12 12月 2013 01:00     1
                              12976 12 12月 2013 02:00     1
                              12977 12 12月 2013 03:00     1
                              12978 12 12月 2013 04:00     1
                              12979 12 12月 2013 05:00     1
                              12980 12 12月 2013 06:00     1
                              12981 12 12月 2013 07:00     1
                              12982 12 12月 2013 08:00     1
                              12983 12 12月 2013 09:00     1
                              12984 12 12月 2013 10:00     1
                              12985 12 12月 2013 11:00     1
                              12986 12 12月 2013 12:00     1
                              12987 12 12月 2013 13:00     1
                              12988 12 12月 2013 14:00     1
                              12989 12 12月 2013 15:00     1
                              12990 12 12月 2013 16:00     1

 

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
输入 begin_snap 的值:  12989
Begin Snapshot Id specified: 12989

输入 end_snap 的值:  12990
End   Snapshot Id specified: 12990

 

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

输入 report_name 的值:  /home/oracle/awr.html

生成的文件在 /home/oracle/awr.html

 


Whatever is worth doing is worth doing well.