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(30)`	`NOT NULL`	Name of the SQL tuning set for the statement
`SQLSET_OWNER`	`VARCHAR2(30)`		User name of the SQL tuning set owner
`SQLSET_ID`	`NUMBER`	`NOT NULL`	ID of the SQL tuning set for the statement
`SQL_ID`	`VARCHAR2(13)`	`NOT NULL`	SQL identifier of the parent cursor in the library cache
`FORCE_MATCHING_SIGNATURE`	`NUMBER`	`NOT NULL`	The signature used when the `CURSOR_SHARING` parameter is set to `FORCE`
`PLAN_HASH_VALUE`	`NUMBER`	`NOT NULL`	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`	`NOT NULL`	Position
`VALUE`	`ANYDATA`		Value
`CAPTURED`	`CHAR(1)`		Binds captured
`SQL_SEQ`	`NUMBER`	`NOT NULL`	SQL sequence