Oracle 根据SQLID查询绑定变量的传入值
select b.NAME,
b.POSITION,
b.DATATYPE_STRING,
b.VALUE_STRING,
b.LAST_CAPTURED
from v$sql_bind_capture b
where b.sql_id = '7npujs1a1msdd';
--查询当前
select b.name, b.datatype_string, b.value_string, b.last_captured
from dba_hist_sqlbind b
where b.sql_id = 'd01huhnwwf5rx'
order by 4;
--查询历史