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"