SQL bind extract

To check bind info from v$sql

SELECT dbms_sqltune.extract_bind(bind_data,1).value_string FROM V$SQL WHERE SQL_ID=’8j9q64g6ctqbq’;
SELECT dbms_sqltune.extract_bind(bind_data,2).value_string FROM V$SQL WHERE SQL_ID=’8j9q64g6ctqbq’;

To check bind info from AWR
========================
create sql tuning set from awr, which includes target sql statements
check dba_sqlset_statements, table for sql and bind availability(bind_data,bind_captured columns)
then use dbms_sqltune.EXTRACT_BIND function to get bind info


This is available only in 11g