8.14 V$ALL_SQL_BIND_CAPTURE

V$ALL_SQL_BIND_CAPTURE displays information on bind variables used by SQL cursors.

Note:

V$ALL_SQL_BIND_CAPTURE allows application developers to view information about their own bind variables used by SQL cursors. It is similar to the V$SQL_BIND_CAPTURE view, with the following exception:

  • When queried by a user with the SYSDBA privilege, the V$ALL_SQL_BIND_CAPTURE view displays the same data as the V$SQL_BIND_CAPTURE view.

  • When queried by any other user, the V$ALL_SQL_BIND_CAPTURE view displays only data about bind variables used by the SQL cursors owned by that user.

See also "V$SQL_BIND_CAPTURE"

Column Datatype Description

ADDRESS

RAW(4 | 8)

Address of the parent cursor

HASH_VALUE

NUMBER

Hash value of the parent cursor in the library cache. The hash value is a fixed index for the view and should always be used to speed up access to the view.

SQL_ID

VARCHAR2(13)

SQL identifier of the parent cursor in the library cache

CHILD_ADDRESS

RAW(4 | 8)

Address of the child cursor

CHILD_NUMBER

NUMBER

Child cursor number

NAME

VARCHAR2(128)

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 data type. Beginning in Oracle Database 12c, a number representing a PL/SQL data type can appear in this column.

DATATYPE_STRING

VARCHAR2(15)

Textual representation of the bind data type. Beginning in Oracle Database 12c, a text representation of a PL/SQL-only data type can appear in this column. If the actual data type is a PL/SQL sub type, the name of the data type, not the sub type will be displayed.

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

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

Note:

This view is available starting with Oracle Database 23ai.