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 |
CHILD_NUMBER |
NUMBER |
|
Child cursor number |
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. |
