Oracle AWR 报告中 No data exists for this section of the rep

1、oracle awr 报告中 no data exists for this section of the rep在awr中，假如有部分选项是：nodata ists for this section of the report.那么属正常现象。 如： 那么现在看一个有数据的awr: 在下面的这个图中就显示了显示的条件：（1）sql orderby sharable memory：only statements with sharable memory greater than 1048576 are displayed（2）sql orderedby version count：only s

2、tatements with version count greater than 20 are displayed 惟独达到条件的状况下，才会显示该项的数据。所以假如浮现no data exists for this section of the report.就解释还没达到条件。 假如说不是局部选项，而是所有都是no data exists for this section of the report，那么awr的相关参数设置可能就有问题。 在oracle 10g和11g 都有的参数：istics_level，假如该参数设置为basic，那么会禁用如下功能：(1) automatic wo

3、rkload repository(awr) snapshots(2) automatic database diagnosticmonitor (addm)(3) all server-generated alerts(4) automatic sga memory management(5) automatic optimizer statisticslection(6) object level statistics(7) end to end appliion tracing(v$client_stats)(8) database disibutionstatistics (v$ses

4、s_time_model and v$sys_time_model)(9) service level statistics(10) buffer cache advisory(11) mttr advisory(12) shared pool sizing advisory(13) segment level statistics(14) pga target advisory(15) timed statistics(16) monitoring of statistics 该参数默认是typical：sys show parameter statistics name type valu

5、e- -statistics_level string typicaltimed_os_statistics integer 0timed_statistics boolean true 详见我的blog：oracle awr 介绍 用法如下sql 查看相关的设置：/* foatted on 2011/12/1610:30:17 (qp5 v5.185.11230.41888) */ selectstatistics_name, session_status, system_status, activation_level, session_table from v$statistics_le

6、vel order by statistics_name;在oracle 11g 下，多了一个control_management_pack_access参数，该参数可以影响awr信息的收集：sql show parameter control_management_pack_access name type value- -control_management_pack_access string diagnostic+tuning 对企业版的默认值是diagnostic+tuning，如上所示。 propertydescriptionparameter typestringsyntaxco

7、ntrol_management_pack_access = none | diagnostic | diagnostic+tuning default valueenterprise edition: diagnostic+tuningall other editions: nonemodifiablealter systembasicno control_management_pack_access specifies of the server manageability packs should be active. the following packsare available:

8、the diagnostic pack iludes awr, addm, and so on. the tuning pack includes sql tuning advisor, sqlaccess advisor, and so on.a license for diagnostic is required for enabling the tuning pack. 对这个参数的说明，参考： 假如在oracle 11g里该参数不正确，也会影响awr等信息的收集，可以通过如下语句修改：sql alter system set control_management_pack_access

9、='diagnostic+tuning' scope=both;system altered. 小结：1. 假如部分选项浮现no data exists for this section of the report.属正常现象。 2. 假如所有浮现，则需要检查相关参数10g中检查statistics_level，11g中检查statistics_level和control_management_pack_access参数。 -版权全部，文章允许转载，但必需以链接方式注明源地址，否则追究法律责任! blog: tianlesoftwareskype: tianlesoftware -加群需要在备注解释oracle表空间和数据文件的关系，否则否决申请-dba1 群：62697