DBA_HIST_SQLBIND

DBA_HIST_SQLBIND displays historical information on bind variables used by SQL cursors. This view contains snapshots of V$SQL_BIND_CAPTURE.

Column Datatype NULL Description
SNAP_ID NUMBER   Unique snapshot ID
DBID NUMBER   Database ID for the snapshot
INSTANCE_NUMBER NUMBER   Instance number for the snapshot
SQL_ID VARCHAR2(13)   SQL identifier of the parent cursor in the library cache
NAME VARCHAR2(30)   Name of the bind variable
POSITION NUMBER   Position of the bind variable in the SQL statement
DUP_POSITION NUMBER   If the binding is performed by name and the bind variable is duplicated, then this column gives the position of the primary bind variable.
DATATYPE NUMBER   Internal identifier for the bind datatype
DATATYPE_STRING VARCHAR2(15)   Textual representation of the bind datatype
CHARACTER_SID NUMBER   National character set identifier
PRECISION NUMBER   Precision (for numeric binds)
SCALE NUMBER   Scale (for numeric binds)
MAX_LENGTH NUMBER   Maximum bind length
WAS_CAPTURED VARCHAR2(3)   Indicates whether the bind value was captured (YES) or not (NO)
LAST_CAPTURED DATE   Date when the bind value was captured. Bind values are captured when SQL statements are executed. To limit the overhead, binds are captured at most every 15 minutes for a given cursor.
VALUE_STRING VARCHAR2(4000)   Value of the bind represented as a string
VALUE_ANYDATA ANYDATA   Value of the bind represented using the self-descriptive Sys.AnyData datatype. This representation is useful to programmatically decode the value of the bind variable.