Can you help me to understand the difference between PLSQL_EXEC_TIME and ELAPSED_TIME in v$sqlarea
Hi,
I would like to understand what it is the difference between the column PLSQL_EXEC_TIME and ELAPSED_TIME, for example in my database I could gather the following values:
SQL> select PLSQL_EXEC_TIME,CPU_TIME, ELAPSED_TIME from v$sqlarea where sql_id='9dfqafknxuwk0'
PLSQL_EXEC_TIME CPU_TIME ELAPSED_TIME
---------------- ---------------- ----------------
4.721.206.289.994 18.520.873.588.044 18.906.904.039.607
Why the PLSQL_EXEC_TIME it is lower than the ELAPSED_TIME?
ELAPSED_TIME it is the portion of the DBTime contributed by this SQLID?
Regards