Database Tuning (MOSC)

MOSC Banner

v$sql, child cursors and elapsed time

edited Aug 3, 2017 5:00AM in Database Tuning (MOSC) 5 commentsAnswered

Hi all,

I have some questions about the v$sql, cursors and the elapsed time of the query.

select sql_id,elapsed_time, executions, users_executing, plan_hash_value,to_char(last_active_time,'DD/MM/YYYY HH24:MI:SS') , px_servers_executions

from v$sql where sql_id = '11n97qcyh15g6' ;

select sql_id,address,child_address,child_number,bind_mismatch

from v$sql_shared_cursor

where sql_id = '11n97qcyh15g6';

If I'm correct, there is one parent cursor and one child cursor because of a 'bind mismatch'.

What I don't understand is the values of the elapsed_time and executions columns: how a statement can have 0 execution and an elapsed time so important ?

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