关于AWR部分列显示异常
最近看一份AWR报告的时候，发现总是有部分列里面显示#######，类似于excel中的列宽不够出现的错误，判断也应该是由于列宽不够造成的，群里面讨论了也没有什么结果，想来可能只有通过修改AWR的脚本才能修正过来，但是不知道如何修改，请指教 一个好的问题 的基本要素：一个好的标题、 完整的版本信息、 完整的日志信息、 报错信息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的时间跨度 ，或者升级数据库。 原来是bug啊 影响不大一直没太在意 呵呵呵呵呵呵呵呵
页:
[1]