BIND variables

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,
 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';

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.