Database Tuning (MOSC)

MOSC Banner

understanding elapsed_time in v$sql

edited Sep 29, 2016 10:07AM in Database Tuning (MOSC) 7 commentsAnswered

Hello Oracle Gurus,

Elapsed_time in v$sql=CPU_TIME + APPLICATION_WAIT_TIME + CONCURRENCY_WAIT_TIME + CLUSTER_WAIT_TIME + USER_IO_WAIT_TIME + PLSQL_EXEC_TIME+ JAVA_EXEC_TIME

1.i sometimes see that elapsed_time does not add to the sum of above things..why does that happen and where do i find the missing time of elapsed time ?

2.Also i see in Sql monitoring OEM it sometime shows "other" in "Database time"...which is not in v$sql.

3. Is last_active_time - last_load_time always equal to Elapsed_time ? if not does it include non-idle wait events like '

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