VIEW: SYS._ALL_SQLSET_STATEMENTS_PHV

Source

View Text - Preformatted

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,
       s.command_type, p.parsing_schema_name,
       substrb(s.module, 1, (select ksumodlen from x$modact_length)) module,
       substrb(s.action, 1, (select ksuactlen from x$modact_length)) action,
       p.plan_timestamp, p.binds_captured, s.id as sql_seq
from   WRI$_SQLSET_DEFINITIONS d, WRI$_SQLSET_STATEMENTS s,
       WRI$_SQLSET_PLANS p
where  d.id = s.sqlset_id AND s.id = p.stmt_id 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 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
, S.COMMAND_TYPE
, P.PARSING_SCHEMA_NAME
, SUBSTRB(S.MODULE
, 1
, (SELECT KSUMODLEN
FROM X$MODACT_LENGTH)) MODULE
, SUBSTRB(S.ACTION
, 1
, (SELECT KSUACTLEN
FROM X$MODACT_LENGTH)) ACTION
, P.PLAN_TIMESTAMP
, P.BINDS_CAPTURED
, S.ID AS SQL_SEQ FROM WRI$_SQLSET_DEFINITIONS D
, WRI$_SQLSET_STATEMENTS S
, WRI$_SQLSET_PLANS P WHERE D.ID = S.SQLSET_ID
AND S.ID = P.STMT_ID 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*/)))