查詢Oraclesql語句中綁定變量值的方法

查詢Oraclesql語句中綁定變量值的方法

alter session set nls_date_format = 'yyyy-mm-dd,hh24:mi:ss';

set linesize 400

col sql_Id format a20

col name format a20

col datatype_string format a14

col value_string format a20




select sql_id,name, datatype_string, last_captured,value_string from v$sql_bind_capture where sql_id='dxfcacn4t4ppw' order by LAST_CAPTURED,POSITION;

--在出問題的實例上執行,請自行替換sql_id,此時該sql還在shared pool中，沒有被aged out




select instance_number,  sql_id,name, datatype_string, last_captured,value_string from dba_hist_sqlbind where sql_id='fahv8x6ngrb50'order by LAST_CAPTURED,POSITION;

--請自行替換sql_id，此時是從awr中查詢。