Return
-
Title
Where can I find information regarding the SGA Inspector Statistics window? -
Description
Where can I find information regarding the SGA Inspector Statistics window? For example, is the ELAPSED_TIME column, an accumulated total, or an average for the amount of times the sql statement has been executed.
-
Resolution
Help | Contents | SGA Inspector | Using SGA Inspector | Add Inspector Job | Statistics
and
Help | Contents | SGA Inspector | Using SGA Inspector | Identify Problematic SQL in SGA
will provide definitions for each of the statistic columns.
Please refer to Oracle documentation regarding stats in the Oracle SQL Area -
Additional Information
The ELAPSED_TIME is retrieved from Oracle SQL Area. Starting from Oracle 9i, the elapsed time is an accumulative value. So, dividing it by the executions column will produces the average amount of time per execution.