SQL Elapsed Time for Parallel Queries in AWR Report is Higher Than the Actual Elapsed Time
(Doc ID 1956033.1)
Last updated on AUGUST 26, 2021
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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!
In this Document