Query the method for binding variable values in Oracle SQL statements, oraclesql

Query the method for binding variable values in Oracle SQL statements, oraclesql

Alter session set nls_date_format = 'yyyy-mm-dd, hh24: mi: ss'; set linesize 400col SQL _Id format a20col name format a20col datatype_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; -- run the command on the faulty instance. Replace SQL _id by yourself, at this time, the SQL statement is still in the shared pool and is not replaced by aged outselect instance_number. , SQL _id, name, datatype_string, last_captured, value_string from dba_hist_sqlbind where SQL _id = 'hangzhou' order by LAST_CAPTURED, POSITION; -- replace SQL _id, Which is queried from awr.