Unaccounted Time in 10046 File on AIX SMT4 Platform when Comparing Elapsed and CPU Time
Last updated on JULY 14, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms