VIEW: SYS.ALL_SQLSET_BINDS

Source

View Text - Preformatted

select name as sqlset_name, d.owner as sqlset_owner, sqlset_id, s.con_dbid,
         sql_id, force_matching_signature, p.plan_hash_value,
         b.position, b.value, p.binds_captured as captured, s.id as sql_seq
  from   WRI$_SQLSET_DEFINITIONS d, WRI$_SQLSET_STATEMENTS s,
         WRI$_SQLSET_PLANS p, WRI$_SQLSET_BINDS b
  where  d.id = s.sqlset_id AND
         s.id = p.stmt_id AND s.con_dbid = p.con_dbid AND
         p.stmt_id = b.stmt_id AND
         p.plan_hash_value = b.plan_hash_value AND
         p.con_dbid = b.con_dbid AND
         (d.owner = SYS_CONTEXT('USERENV', 'CURRENT_USER')  OR
         EXISTS (select 1
                 from  V$ENABLEDPRIVS
                 where priv_number in (-273 /*ADMINISTER ANY SQL TUNING SET*/)))
  UNION ALL
  select d.name as sqlset_name, d.owner as sqlset_owner, s.sqlset_id,
         s.con_dbid, s.sql_id, s.force_matching_signature, p.plan_hash_value,
         b.position, b.value_anydata as value, p.binds_captured as captured,
         s.id as sql_seq
  from   WRI$_SQLSET_DEFINITIONS d, WRI$_SQLSET_STATEMENTS s,
         WRI$_SQLSET_PLANS p, TABLE(dbms_sqltune.extract_binds(p.bind_data)) b
  where  d.id = s.sqlset_id AND s.id = p.stmt_id AND s.con_dbid = p.con_dbid
         AND (d.owner = SYS_CONTEXT('USERENV', 'CURRENT_USER') OR
         EXISTS (select 1
                 from  V$ENABLEDPRIVS
                 where priv_number in (-273 /*ADMINISTER ANY SQL TUNING SET*/)))

View Text - HTML Formatted

SELECT NAME AS SQLSET_NAME
, D.OWNER AS SQLSET_OWNER
, SQLSET_ID
, S.CON_DBID
, SQL_ID
, FORCE_MATCHING_SIGNATURE
, P.PLAN_HASH_VALUE
, B.POSITION
, B.VALUE
, P.BINDS_CAPTURED AS CAPTURED
, S.ID AS SQL_SEQ
FROM WRI$_SQLSET_DEFINITIONS D
, WRI$_SQLSET_STATEMENTS S
, WRI$_SQLSET_PLANS P
, WRI$_SQLSET_BINDS B
WHERE D.ID = S.SQLSET_ID AND S.ID = P.STMT_ID
AND S.CON_DBID = P.CON_DBID AND P.STMT_ID = B.STMT_ID AND P.PLAN_HASH_VALUE = B.PLAN_HASH_VALUE AND P.CON_DBID = B.CON_DBID AND (D.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR EXISTS (SELECT 1
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-273 /*ADMINISTER ANY SQL TUNING SET*/))) UNION ALL SELECT D.NAME AS SQLSET_NAME
, D.OWNER AS SQLSET_OWNER
, S.SQLSET_ID
, S.CON_DBID
, S.SQL_ID
, S.FORCE_MATCHING_SIGNATURE
, P.PLAN_HASH_VALUE
, B.POSITION
, B.VALUE_ANYDATA AS VALUE
, P.BINDS_CAPTURED AS CAPTURED
, S.ID AS SQL_SEQ
FROM WRI$_SQLSET_DEFINITIONS D
, WRI$_SQLSET_STATEMENTS S
, WRI$_SQLSET_PLANS P
, TABLE(DBMS_SQLTUNE.EXTRACT_BINDS(P.BIND_DATA)) B
WHERE D.ID = S.SQLSET_ID
AND S.ID = P.STMT_ID
AND S.CON_DBID = P.CON_DBID
AND (D.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR EXISTS (SELECT 1
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-273 /*ADMINISTER ANY SQL TUNING SET*/)))