V$SQL_BIND_DATA

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