ALL_SQLSET_BINDS

Previous Next JavaScript must be enabled to correctly display this content

3.81 ALL_SQLSET_BINDS

ALL_SQLSET_BINDS displays the bind values associated with all SQL tuning sets accessible to the current user.

Related Views

DBA_SQLSET_BINDS displays the bind values associated with all SQL tuning sets in the database.
USER_SQLSET_BINDS displays the bind values associated with the SQL tuning sets owned by the current user. This view does not display the SQLSET_OWNER column.

Column	Datatype	NULL	Description
`SQLSET_NAME`	`VARCHAR2(128)`		Name of the SQL tuning set for the statement
`SQLSET_OWNER`	`VARCHAR2(128)`		User name of the SQL tuning set owner
`SQLSET_ID`	`NUMBER`		ID of the SQL tuning set for the statement
`CON_DBID`	`NUMBER`		The database ID of the PDB
`SQL_ID`	`VARCHAR2(13)`		SQL identifier of the parent cursor in the library cache
`FORCE_MATCHING_SIGNATURE`	`NUMBER`		The signature used when the `CURSOR_SHARING` parameter is set to `FORCE`
`PLAN_HASH_VALUE`	`NUMBER`		Numerical representation of the SQL plan for the cursor. Comparing one `PLAN_HASH_VALUE` to another easily identifies whether or not two plans are the same (rather than comparing the two plans line-by-line).
`POSITION`	`NUMBER`		Bind position
`VALUE`	`ANYDATA`		Bind value. This column is `NULL` for PL/SQL bind types.
`CAPTURED`	`CHAR(1)`		Binds captured
`SQL_SEQ`	`NUMBER`		SQL sequence

See Also:

"DBA_SQLSET_BINDS"
"USER_SQLSET_BINDS"