VIEW: SYS.ALL_SQLSET_REFERENCES

Source

View Text - Preformatted

select d.name as sqlset_name, d.owner as sqlset_owner, r.sqlset_id,
       r.id, r.owner, r.description, r.created
from   wri$_sqlset_definitions d, wri$_sqlset_references r
where d.id=r.sqlset_id AND
      (d.owner = SYS_CONTEXT('USERENV', 'CURRENT_USER') OR
       r.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
, R.SQLSET_ID
, R.ID
, R.OWNER
, R.DESCRIPTION
, R.CREATED FROM WRI$_SQLSET_DEFINITIONS D
, WRI$_SQLSET_REFERENCES R WHERE D.ID=R.SQLSET_ID AND (D.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR R.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR EXISTS (SELECT 1
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-273 /*ADMINISTER ANY SQL TUNING SET*/)))