返回
-
标题
Definition of Active time, Elapsed time, CPU time in SQL PI -
说明
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 -
解决办法
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.