v$sql, child cursors and elapsed time
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 ?