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 AI Database 26ai.