Incorrect Percent Total Call Time in Top 5 Timed Events of AWR Report (Doc ID 1326166.1)

Last updated on MARCH 05, 2013

Applies to:

Oracle Database - 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms