Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_SQLSET_BINDS

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

Related Views

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