-
Titre
Definition of Active time, Elapsed time, CPU time in SQL PI -
Description
What is the difference between "Active time", "Elapsed time" and "CPU time" in Top SQL Statements view ?Database | SQL Performance | Workload | Instance View | SQL Statements | Top SQL Statements -
Résolution
The screenshot below describes definition of Active Time in different databases
SQL Server
Sum of all the active waits and cpu usage, equal to the session total activity within the current interval.
Oracle
Sum of all CPU Usage and non-Idle wait time, equal to the session total activity within the current interval.
Elapsed Time is the total time consumed for carrying out the SQL statement executions.
CPU Time is the total CPU time consumed for carrying out the SQL statement executions.How can Active Time be more than Elapsed Time?SQL Server can run queries in parallel so that multiple threads might be executing parts of the query simultaneously.
Let's consider elapsed time as the total wall-clock time (i.e., the actual time passed from the start to the end of the query execution), while active time being the sum of all the active wait times and CPU times for each parallel thread.