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 18.104.22.168 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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms