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 laterOracle 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)
Symptoms
- After upgrading database to 11.2.0.4, 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 <<<
Changes
Upgrade of database from 9.2.0.8 to 11.2.0.4 in IBM AIX 6.1.
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 |
| References |