V$SQL_BIND_DATA describes, for each distinct bind variable in each cursor owned by the session querying this view:
Actual bind data, if the bind variable is user defined
The underlying literal, if the CURSOR_SHARING parameter is set to FORCE and the bind variable is system generated. (System-generated binds have a value of 256 in the SHARED_FLAG2 column.)
| Column | Datatype | Description | 
|---|---|---|
CURSOR_NUM | 
NUMBER | 
Cursor number for this bind | 
POSITION | 
NUMBER | 
Bind position | 
DATATYPE | 
NUMBER | 
Bind datatype | 
SHARED_MAX_LEN | 
NUMBER | 
Shared maximum length for this bind from the shared cursor object associated with this bind | 
PRIVATE_MAX_LEN | 
NUMBER | 
Private maximum length for this bind sent from the client | 
ARRAY_SIZE | 
NUMBER | 
Maximum number of array elements (for array binds only) | 
PRECISION | 
NUMBER | 
Precision (for numeric binds) | 
SCALE | 
NUMBER | 
Scale (for numeric binds) | 
SHARED_FLAG | 
NUMBER | 
Shared bind data flags | 
SHARED_FLAG2 | 
NUMBER | 
Shared bind data flags (continued) | 
BUF_ADDRESS | 
RAW(4 | 8) | 
Bind buffer memory address | 
BUF_LENGTH | 
NUMBER | 
Bind buffer length | 
VAL_LENGTH | 
NUMBER | 
Actual bind value length | 
BUF_FLAG | 
NUMBER | 
Bind buffer flags | 
INDICATOR | 
NUMBER | 
Bind indicator | 
VALUE | 
VARCHAR2(4000) | 
Contents of the bind buffer |