Query Unjustified High Execution Time Might Actually Be Spent In PL/SQL Mode
(Doc ID 3048930.1)
Last updated on NOVEMBER 10, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
SQL statement exhibits high execution time, but it is not very clear from where the execution time could actually come.
For example, you've taken a 10046 trace file and the execution time doesn't add up. An example of this, below. Notice 28K seconds from the "Execute" section. The actual plan lines however, only indicate 1798 seconds of execution time. Unfortunately there is no hint of where the rest of the time is being spent. It is not in the Wait Times section either.
Changes
No changes, this can apply to any SQL Statement in any version
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 |