获取绑定变量值

1、dba_hist_sqlbind和v$sql_bind_capture

2、一条sql对应多条v$sql行时

select * from table(dbms_sqltune.extract_binds('v$sql中的bind_data值'));

3、v$sql不存在时可尝试　

select dbms_sqltune.extract_bind(bind_data, 1).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 2).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 3).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 4).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 5).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 6).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 7).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 8).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 9).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 10).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 11).value_string || '-' ||
dbms_sqltune.extract_bind(bind_data, 12).value_string
from sys.wrh$_sqlstat
where sql_id = '4y4mj3vttz7fh';