VIEW: SYS.KU$_ROLLBACK_VIEW

Source

View Text - Preformatted

select '1','0',
         u.us#,
         u.name,
         u.user#,
         (select r.optsize from v$rollstat r where r.usn=u.us#),
         s.iniexts,
         s.minexts,
         s.maxexts,
         s.extsize,
         value(tsv)
  from   sys.ku$_tablespace_view tsv, sys.seg$ s, sys.undo$ u
  where  u.status$ != 1
    and  u.ts# = tsv.ts_num
    and  u.file#  = s.file#
    and  u.block# = s.block#
    and  u.ts#    = s.ts#
    and (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
        OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, U.US#
, U.NAME
, U.USER#
, (SELECT R.OPTSIZE
FROM V$ROLLSTAT R
WHERE R.USN=U.US#)
, S.INIEXTS
, S.MINEXTS
, S.MAXEXTS
, S.EXTSIZE
, VALUE(TSV)
FROM SYS.KU$_TABLESPACE_VIEW TSV
, SYS.SEG$ S
, SYS.UNDO$ U
WHERE U.STATUS$ != 1
AND U.TS# = TSV.TS_NUM
AND U.FILE# = S.FILE#
AND U.BLOCK# = S.BLOCK#
AND U.TS# = S.TS#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))