AWR shows incorrect cpu time in IBM AIX
(Doc ID 1631769.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
IBM AIX on POWER Systems (64-bit)
- After upgrading database to 126.96.36.199, AWR reports is showing very high DB-Time in IBM AIX 6.1 (this is also applicable to AIX 7.1)
Statistic Name Time (s) % of DB Time
DB CPU 17,582,053,544.85 100.00 <<<
sql execute elapsed time 3,099.53 0.00
parse time elapsed 1,239.93 0.00
- But the "Operating System Statistics - Detail" section of the AWR do not show much cpu utilization
Snap Time Load %busy %user %sys %idle %iowait
16-Dec 21:59:33 0.77
16-Dec 22:26:07 1.04 3.58 2.14 1.43 96.42 6.26 <<<
Upgrade of database from 188.8.131.52 to 184.108.40.206 in IBM AIX 6.1.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!