VIEW: SYS.USER_SQLSET_BINDS

Source

View Text - Preformatted

select name as sqlset_name, sqlset_id, s.con_dbid,
         s.sql_id, s.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')
  UNION ALL
  select d.name as sqlset_name, 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')

View Text - HTML Formatted

SELECT NAME AS SQLSET_NAME
, SQLSET_ID
, S.CON_DBID
, S.SQL_ID
, S.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') UNION ALL SELECT D.NAME AS SQLSET_NAME
, 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')