Methods for querying the values of bound variables in an Oracle SQL statement

Alter session Set Nls_date_format = ' Yyyy-mm-dd,hh24:mi:ss '; set linesize 400col sql_id format a20col name format A20col da tatype_string format a14col value_string format A20select sql_id,name, datatype_string, last_captured,value_string from V$sql_bind_capture where sql_id= ' DXFCACN4T4PPW ' ORDER by last_captured,position;--is executed on the problematic instance, please replace the sql_id yourself, At this point the SQL is still in the shared pool, not aged outselect instance_number,  sql_id,name, datatype_string, Last_captured,value_ String from Dba_hist_sqlbind the where sql_id= ' fahv8x6ngrb50 ' ORDER by last_captured,position;--please replace the sql_id yourself, and this is the query from the AWR.

Methods for querying the values of bound variables in an Oracle SQL statement