Dynamic Performance (V$) Views, 152 of 179

V$SQL_BIND_DATA

For each distinct bind variable in each cursor owned by the session querying this view, this view describes:

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 in the SHARED_FLAG2 column of 256.)

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)

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

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)`	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