SQL Elapsed Time for Parallel Queries in AWR Report is Higher Than the Actual Elapsed Time
(Doc ID 1956033.1)
Last updated on FEBRUARY 03, 2019
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later Information in this document applies to any platform.
SQL under the section "SQL ordered by Elapsed Time" is seen to be higher than the expected execution time In the example below the query is indicated to have taken 240.93 seconds whereas it only took 30 seconds to complete
SQL is running in parallel as seen in the execution plan:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!