VIEW: SYS.EXU8RSG

Source

View Text - Preformatted

SELECT  'SYSTEM', r$.name, ts$.name, r$.ts#, r$.file#, r$.block#,
                s$.minexts, DECODE(r$.user#, 1, 1, 0)
        FROM    sys.ts$ ts$, sys.undo$ r$, sys.seg$ s$
        WHERE   r$.status$ != 1 AND
                r$.file# = s$.file# AND
                r$.block# = s$.block# AND
                s$.ts# = ts$.ts# AND
                r$.ts# = s$.ts# AND
                r$.us# != 0 AND
                BITAND(ts$.flags, 16) = 0                 /* undo tablespace */

View Text - HTML Formatted

SELECT 'SYSTEM'
, R$.NAME
, TS$.NAME
, R$.TS#
, R$.FILE#
, R$.BLOCK#
, S$.MINEXTS
, DECODE(R$.USER#
, 1
, 1
, 0)
FROM SYS.TS$ TS$
, SYS.UNDO$ R$
, SYS.SEG$ S$
WHERE R$.STATUS$ != 1 AND R$.FILE# = S$.FILE# AND R$.BLOCK# = S$.BLOCK# AND S$.TS# = TS$.TS# AND R$.TS# = S$.TS# AND R$.US# != 0 AND BITAND(TS$.FLAGS
, 16) = 0 /* UNDO TABLESPACE */