How to find the bind variable of the sql id

Sometimes a sql_id might show a different plan because of a particular value of the bind variable. So we would like to find out the bind variable. Also, we might want to know the bind variable for the sql_id being executed by the session. In this post, we will check out How to find the bind variable of the sql id

SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
COLUMN sql_text FORMAT A120
COLUMN sql_id FORMAT A13
COLUMN bind_name FORMAT A10
COLUMN bind_value FORMAT A26
SELECT sql_id, t.sql_text sql_text, b.name bind_name, b.value_string bind_value FROM 
v$sql t JOIN v$sql_bind_capture b 
using (sql_id) WHERE b.value_string is not null AND sql_id='&sqlid' 
/

or

SELECT name, position, datatype_string, value_string
FROM v$sql_bind_capture
WHERE sql_id = '&1‘;

Related Articles
Bind Variable in Oracle