Unaccounted Time in 10046 File on AIX SMT4 Platform when Comparing Elapsed and CPU Time
(Doc ID 1963791.1)
Last updated on MARCH 30, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
- 10046 trace shows that "elapsed time" of one SQL is larger than "cpu time + wait time"
- 10046 shows significant waits for "SQL*NET message from client"
- In the following example, the elapsed time is 142.64 seconds, which is far larger than 86.86 seconds (cpu time) + 7.06 seconds (waited time):
SMT4 was enabled (OS platform is AIX power 7).
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