../E40402-16.epub /> ../E40402-16.mobi />

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