Find Bind value in Oracle

Here are below  query that help you to find the value of bind variable.

1. From V$sql_bind_capture:

SELECT NAME,POSITION,DATATYPE_STRING,VALUE_STRING, WAS_CAPTURED, LAST_CAPTURED
FROM v$sql_bind_capture WHERE sql_id='8v176wjqww15y';

2. From RAC:

SELECT NAME,POSITION,DATATYPE_STRING,VALUE_STRING,WAS_CAPTURED, LAST_CAPTURED
FROM gv$sql_bind_capture WHERE sql_id='8v176wjqww15y' and inst_id=1;

3. From DBA_HIST_SQLBIND:

SELECT NAME,POSITION,DATATYPE_STRING,VALUE_STRING,WAS_CAPTURED, LAST_CAPTURED
FROM DBA_HIST_SQLBIND WHERE SQL_ID='8v176wjqww15y' and SNAP_ID='12345';