My Oracle Support Banner

Time Missing Between Time Model CPU And Top SQL Ordered by CPU Time in AWR (Doc ID 2861976.1)

Last updated on APRIL 12, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.12.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In an AWR, the top 10 captured "SQL ordered by CPU Time" account for only a fraction of the CPU seconds showing in "Time Model Statistics" and "Top Timed Events" for CPU time.  You need to know why the time in the reported SQL is missing.

Example: Of the 44,408.57 total CPU seconds reported in "Time Model Statistics," only 22.6% of that is reported as captured SQL, and only the top 10 SQL ordered by CPU are reported (about 21.23% of the 44,408.57 seconds).

 

The following is plotted output from an awrextr of the same information (internal Oracle tool only).  Note the top wavy green line, which represents the CPU seconds reported in the Time Model Statistics.

You could also see the issue if you ran queries, such as these:

 

Changes

 Upgrade to 19c, but this same issue could be seen in other versions, as well.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.