oracle查看sql中的绑定变量

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

set linesize 300
col sql_Id format a25
col name format a25
col datatype_string format a20
col value_string format a20

#sql还在shared pool中
select sql_id, name, datatype_string, last_captured, value_string
  from v$sql_bind_capture
 where sql_id = 'xxxxxxxxxxxxxxx'
 order by LAST_CAPTURED, POSITION; 
 
 
#从awr中查看
select instance_number,
       sql_id,
       name,
       datatype_string,
       last_captured,
       value_string
  from dba_hist_sqlbind
 where sql_id = 'xxxxxxxxxxxxxxx'
 order by LAST_CAPTURED, POSITION;