使用awrrpt.sql 生成AWR报告的方法
使用/home/oracle/app/oracle/product/11.2.9/dbhome_1/rdbms/admin/awrrpt.sql脚本生成awr报告oracle@linux:~> sqlplus / as sysdba
SQL*Plus:> Copyright (c) 1982, 2011, Oracle.All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition> With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @/home/oracle/app/oracle/product/11.2.9/dbhome_1/rdbms/admin/awrrpt.sql awrrpt.sql 该脚本的绝对路径；
Current Instance
~~~~~~~~~~~~~~~~
DB> ----------- ------------ -------- ------------
1407296662 ORCL 1 orcl
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: html 报告类型，html或text
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB> ------------ -------- ------------ ------------ ------------
* 1407296662 1 ORCL orcl linux
Using 1407296662 for database> 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.Pressingwithout
specifying a number lists all completed snapshots.
Enter value for num_days: 1 要生成报告的天数，默认是7天
Listing the last day's Completed Snapshots
Snap
Instance DB Name Snap> ------------ ------------ --------- ------------------ -----
orcl ORCL 2179 19 8月2015 00:00 1
2180 19 8月2015 01:00 1
2181 19 8月2015 02:00 1
2182 19 8月2015 03:00 1
2183 19 8月2015 04:00 1
2184 19 8月2015 05:00 1
2185 19 8月2015 06:00 1
2186 19 8月2015 07:00 1
Specify the Begin and End Snapshot> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 2181 开始快照的id 如：2181
Begin Snapshot> Enter value for end_snap: 2183 结束快照的id 如：2183
End Snapshot> Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_2181_2183.html.To use this name,
pressto continue, otherwise enter an> Enter value for report_name: awrrpt_1_2181_2183.html 生成报告的名称
............................................
Report written to awrrpt_1_2181_2183.html 当看到这个表示生成成功了；
oracle@linux:~> ll /home/oracle/awrrpt_1_2181_2183.html
-rw-r--r-- 1 oracle dba 379333 2015-08-19 07:38 /home/oracle/awrrpt_1_2181_2183.html
默认保存在/home/oracle 的路径下；
页:
[1]