9.47 V$SQL_BIND_DATA

V$SQL_BIND_DATA describes information related to bind variables.

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

Internal identifier for the bind data type. Beginning in Oracle Database 12c, a number representing a PL/SQL data type can appear in this column.

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

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also:

"CURSOR_SHARING"