Database Administration (MOSC)

MOSC Banner

Can you help me to understand the difference between PLSQL_EXEC_TIME and ELAPSED_TIME in v$sqlarea

edited Jan 5, 2017 9:30AM in Database Administration (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center