col sid format 9999999999
col username format a8
col sql_hash_value format 999999999999
col sqlid format a14
col sql_child_number format 9
col name format a4
col value_string format a15
col last_captured format a25
select s.sid,
s.username,
s.sql_hash_value,
s.sql_id,
s.sql_child_number,
spc.name,
spc.value_string,
last_captured
from v$sql_bind_capture spc, v$session s,v$sql sq
where s.sql_hash_value = spc.hash_value
and s.sql_address = spc.address
and sq.sql_id=s.sql_id
and spc.was_captured='YES'
--and s.type<>'BACKGROUND'
--and s.status='ACTIVE'
and s.sql_id='&sql_id';
Related