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

Last updated on JULY 20, 2024

Applies to:

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

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