select sid,serial#,status from v$session where username='VINEET';

select b.address,b.hash_value,b.child_number,b.plan_hash_value,b.sql_text
from v$session a, v$sql b
where a.SQL_ADDRESS=b.ADDRESS
and a.sid=138;


COL id FORMAT 999
COL parent_id FORMAT 999 HEADING "PARENT"
COL operation FORMAT a35 TRUNCATE
COL object_name FORMAT a30

SELECT id, parent_id, LPAD (' ', LEVEL - 1) || operation || ' ' ||
options operation, object_name
FROM (
SELECT id, parent_id, operation, options, object_name
FROM v$sql_plan
WHERE address = '&address'
AND hash_value = &hash_value
AND child_number = &child_number
)
START WITH id = 0
CONNECT BY PRIOR id = parent_id;