2.22.2009

Oracle DBA scripts - Bind variable related

Bind variable

1. Find the value of Bind variable

select NAME,POSITION,DATATYPE_STRING,VALUE_STRING from v$sql_bind_capture where sql_id='d9kf91muzy2wq';

v$sql_bind_capture Details: http://youngcow.net/doc/oracle10g/server.102/b14237/dynviews_2114.htm

To get data from history:
DBA_HIST_SQLBIND
DBA_HIST_SQL_BIND_METADATA