AWR shows incorrect cpu time in IBM AIX
(Doc ID 1631769.1)
Last updated on FEBRUARY 14, 2019
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
- After upgrading database to 220.127.116.11, 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 18.104.22.168 to 22.214.171.124 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!
In this Document