?

在AWR中，如果有部分選項(xiàng)是：Nodata exists for this section of the report.那么屬正常現(xiàn)象。

?

如：

?

那么現(xiàn)在看一個(gè)有數(shù)據(jù)的AWR:

?

在下面的這個(gè)圖中就顯示了顯示的條件：

（1）SQL orderedby Sharable Memory：Only Statements with Sharable Memory greater than 1048576 are displayed

（2）SQL orderedby Version Count：Only Statements with Version Count greater than 20 are displayed

?

只有達(dá)到條件的情況下，才會(huì)顯示該項(xiàng)的數(shù)據(jù)。所以如果出現(xiàn)No data exists for this section of the report.就說(shuō)明還沒(méi)達(dá)到條件。

?

如果說(shuō)不是局部選項(xiàng)，而是全部都是No data exists for this section of the report，那么AWR的相關(guān)參數(shù)設(shè)置可能就有問(wèn)題。

?

在Oracle 10g和11g 都有的參數(shù)：statistics_level，如果該參數(shù)設(shè)置為BASIC，那么會(huì)禁用如下功能：

(1)????Automatic Workload Repository(AWR) Snapshots

(2)????Automatic Database DiagnosticMonitor (ADDM)

(3)????All server-generated alerts

(4)????Automatic SGA Memory Management

(5)????Automatic optimizer statisticscollection

(6)????Object level statistics

(7)????End to End Application Tracing(V$CLIENT_STATS)

(8)????Database time distributionstatistics (V$SESS_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

?

該參數(shù)默認(rèn)是typical：

SYS> show parameter statistics

?

NAME???????????????????????????????? TYPE??????? VALUE

----------------------------------------------- ------------------------------

statistics_level???????????????????? string????? TYPICAL

timed_os_statistics????????????????? integer???? 0

timed_statistics???????????????????? boolean???? TRUE

?

詳見我的Blog：

Oracle AWR 介紹

http://blog.csdn.net/tianlesoftware/article/details/4682300

?

使用如下SQL 查看相關(guān)的設(shè)置：

/* Formatted on 2011/12/1610:30:17 (QP5 v5.185.11230.41888) */ SELECTstatistics_name, session_status, system_status, activation_level, session_settable FROM v$statistics_level ORDER BY statistics_name;

在Oracle 11g 下，多了一個(gè)CONTROL_MANAGEMENT_PACK_ACCESS參數(shù)，該參數(shù)可以影響AWR信息的收集：

SQL> show parameter CONTROL_MANAGEMENT_PACK_ACCESS

?

NAME???????????????????????????????? TYPE??????? VALUE

----------------------------------------------- ----------------------

control_management_pack_access?????? string????? DIAGNOSTIC+TUNING

?

對(duì)企業(yè)版的默認(rèn)值是DIAGNOSTIC+TUNING，如上所示。

?

Property	Description
Parameter type	String
Syntax	CONTROL_MANAGEMENT_PACK_ACCESS = { NONE | DIAGNOSTIC | DIAGNOSTIC+TUNING }
Default value	Enterprise Edition:?DIAGNOSTIC+TUNING All other editions:?NONE
Modifiable	ALTER SYSTEM
Basic	No

?

CONTROL_MANAGEMENT_PACK_ACCESS?specifieswhich of the Server Manageability Packs should be active. The following packsare available:

• The?DIAGNOSTIC?pack includes 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.

?

對(duì)這個(gè)參數(shù)的解釋，參考：

http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams037.htm#REFRN10296

?

如果在Oracle 11g里該參數(shù)不正確，也會(huì)影響AWR等信息的收集，可以通過(guò)如下語(yǔ)句修改：

SQL>alter system set control_management_pack_access='DIAGNOSTIC+TUNING' scope=both;

System altered.

?

小結(jié)：

1.?????如果部分選項(xiàng)出現(xiàn)No data exists for this section of the report.屬正常現(xiàn)象。

2.?????如果全部出現(xiàn)，則需要檢查相關(guān)參數(shù)10g中檢查statistics_level，11g中檢查statistics_level和control_management_pack_access參數(shù)。

?

?

?

?

?

?

-------------------------------------------------------------------------------------------------------

版權(quán)所有，文章允許轉(zhuǎn)載，但必須以鏈接方式注明源地址，否則追究法律責(zé)任!

Blog:???? http://blog.csdn.net/tianlesoftware

Weibo: http://weibo.com/tianlesoftware

Email: ? tianlesoftware@gmail.com

Skype: tianlesoftware

?

-------加群需要在備注說(shuō)明Oracle表空間和數(shù)據(jù)文件的關(guān)系，否則拒絕申請(qǐng)----

DBA1 群：62697716(滿);?? DBA2 群：62697977(滿)??DBA3 群：62697850(滿)??

DBA 超級(jí)群：63306533(滿);? DBA4 群：83829929? ?DBA5群： 142216823

DBA6 群：158654907? ??DBA7 群：172855474 ?

轉(zhuǎn)載于:https://www.cnblogs.com/zlja/archive/2011/12/16/2449510.html

《新程序員》：云原生和全面數(shù)字化實(shí)踐50位技術(shù)專家共同創(chuàng)作，文字、視頻、音頻交互閱讀

總結(jié)

以上是生活随笔為你收集整理的Oracle AWR 报告中 No data exists for this section of the report 说明的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。