关于AWR部分列显示异常

yingyifeng

最近看一份AWR报告的时候，发现总是有部分列里面显示#######，类似于excel中的列宽不够出现的错误，判断也应该是由于列宽不够造成的，群里面讨论了也没有什么结果，想来可能只有通过修改AWR的脚本才能修正过来，但是不知道如何修改，请指教

kobe24shou

呵呵呵呵呵呵呵呵

kingofworl

原来是bug啊 影响不大一直没太在意

Maclean Liu(刘相兵

一个好的问题 的基本要素：一个好的标题、　完整的版本信息、 完整的日志信息、 报错信息


key word :  awr pound sign


ODM FINDING:


Incorrect Percent Total Call Time in Top 5 Timed Events of AWR Report

Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.5 - Release: 10.1 to 10.2
Information in this document applies to any platform.
Symptoms
You may have seen a percentage greater than 100 in the Percentage of Total Call Time column of the Top 5 Timed Events in the AWR report.

Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time      
------------------------------ ------------ ----------- ------ ------
cursor: pin S wait on X          97,743,775   1,543,471     16  403.4
Alternatively, you may see pound (or hash) marks, instead of a number.

Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time
------------------------------ ------------ ----------- ------ ------
control file sequential read        482,296      78,471     27 ######

Changes
You have not made any changes to either the database configuration or the Oracle Database software.
Cause
This is a known limitation in calculating Percentage of Total Call Time within Oracle Database Release 10g.  It was investigated in Bug 6331085 and was deemed not to be a bug.  Oracle Database Release 10g does not provide enough information in the AWR to calculate Percentage of Total Call Time accurately in all circumstances.
Solution
Because this has been a known issue, it was addressed in the design and implementation of Release 11g.  In fact you will find that there are actually two charts in the AWR report for 11g: one for the Top 5 Timed Foreground Events, and the other for the Top 5 Timed Background Events.
References
BUG:6331085 - AWRRPT HAS ###### OR OTHER HIGH VALUES FOR % TOTAL CALL TIME



这是10g 在设计上的一个缺陷 对少数过大的统计信息值 可能溢出无法正常显示， 该问题在11g中得到了修复

Workaround方式 是减少 awr interval的时间跨度 ，或者升级数据库。