免费资源部落

本篇内容主要讲解“如何使用awrrpt.sql 生成AWR报告”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何使用awrrpt.sql 生成AWR报告”吧!

使用 /home/oracle/app/oracle/product/11.2.9/dbhome_1/rdbms/admin/awrrpt.sql 脚本生成awr报告

oracle@linux:~>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on 星期三 8月 19 07:34:53 2015Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>@/home/oracle/app/oracle/product/11.2.9/dbhome_1/rdbms/admin/awrrpt.sql awrrpt.sql 该脚本的绝对路径；Current Instance~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance----------- ------------ -------- ------------1407296662 ORCL 1 orclSpecify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Would you like an HTML report, or a plain text report?Enter 'html' for an HTML report, or 'text' for plain textDefaults to 'html'Enter value for report_type:html 报告类型，html或text

Instances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------* 1407296662 1 ORCL orcl linuxUsing 1407296662 for database IdUsing 1 for instance numberSpecify 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> withoutspecifying a number lists all completed snapshots.Enter value for num_days:1 要生成报告的天数，默认是7天Listing the last day's Completed Snapshots SnapInstance DB Name Snap Id Snap Started Level------------ ------------ --------- ------------------ -----orcl ORCL 2179 19 8月 2015 00:00 1 2180 19 8月 2015 01:00 1218119 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 1Specify the Begin and End Snapshot Ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enter value for begin_snap:2181 开始快照的id 如：2181

Begin Snapshot Id specified: 2181Enter value for end_snap:2183 结束快照的id 如：2183End Snapshot Id specified: 2183Specify the Report Name~~~~~~~~~~~~~~~~~~~~~~~The default report file name is awrrpt_1_2181_2183.html. To use this name,press <return> to continue, otherwise enter an alternative.Enter value for report_name:awrrpt_1_2181_2183.html 生成报告的名称

............................................

</body></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 的路径下；

到此，相信大家对“如何使用awrrpt.sql 生成AWR报告”有了更深的了解，不妨来实际操作一番吧！这里是网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！