SELECT value_string 绑定的变量值 FROM v$sql_bind_capture where name='绑定的变量名称'
SELECT s.sid, s.username, sq.sql_text, 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 sq.sql_text like '&pattern';
sql中的参数用:1或:2类似的东 一个绑定的变量
SELECT value_string 绑定的变量值 FROM v$sql_bind_capture where name='绑定的变量名称'
SELECT s.sid, s.username, sq.sql_text, 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 sq.sql_text like '&pattern';