AWR报告的使用

[Oracle@localhost admin]$ pwd/home/oracle/oracle/product/10.2.0/db_1/rdbms/admin[oracle@localhost admin]$ sqlplus sys/lubinsu as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 19 15:12:52 2013 Copyright （c） 1982, 2005, Oracle. All rights reserved. Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options SQL> @/home/oracle/oracle/product/10.2.0/db_1/rdbms/admin/awrrpt.sql Current Instance~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance----------- ------------ -------- ------------1326384392 ORCL 1 orclsid 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 textDefaults to "html"Enter value for report_type: html（也是缺省值）Type Specified: html Instances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------* 1326384392 1 ORCL orclsid localhost.localdomain Using 1326384392 for database IdUsing 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> withoutspecifying a number lists all completed snapshots. Enter value for num_days: 2 Listing the last 2 days of Completed Snapshots SnapInstance DB Name Snap Id Snap Started Level------------ ------------ --------- ------------------ -----orclsid ORCL 220 19 May 2013 10:18 1221 19 May 2013 11:00 1222 19 May 2013 11:42 1223 19 May 2013 12:00 1224 19 May 2013 12:30 1225 19 May 2013 13:00 1226 19 May 2013 13:30 1227 19 May 2013 14:00 1228 19 May 2013 14:30 1229 19 May 2013 15:00 1 Specify the Begin and End Snapshot Ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enter value for begin_snap: 228Begin Snapshot Id specified: 228 Enter value for end_snap: 229End Snapshot Id specified: 229 Specify the Report Name~~~~~~~~~~~~~~~~~~~~~~~The default report file name is awrrpt_1_228_229.html. To use this name,press <return> to continue, otherwise enter an alternative. 可以设置文件名，报告分析之后：我们可以在浏览器中查看报告（这里列出了数据库的整体运行情况，执行时间长的前几条SQL，参数文件，等等，注意AWR只是一个报告，并不会帮助我们分析该如何优化，在后面的ADDM报告则会为我们提供优化的建议）：

自定义 RMAN 显示的日期时间格式Oracle的SGA相关资讯 AWR AWR报告

AWR生成快照间隔调整（06月10日）
AWR信息报告（10/15/2015 20:15:10）
通过Shell脚本抓取AWR报告中的问题（10/08/2015 13:37:59）

手动生成AWR报告（01月01日）
由Oracle Bug引起的AWR Snapshot收（10/09/2015 16:03:38）
关于AWR更多介绍（07/23/2015 16:44:35）

本文评论查看全部评论（0）