VIEW: SYS.DBA_UNDO_EXTENTS

Source

View Text - Preformatted

select /*+ ordered use_nl(e) use_nl(f) */
       'SYS', u.name, t.name,
       e.ktfbueextno, f.file#, e.ktfbuebno,
       e.ktfbueblks * t.BLOCKSIZE, e.ktfbueblks, e.ktfbuefno,
       nullif(e.ktfbuectm, e.ktfbuectm),
       nullif(e.ktfbuestt, e.ktfbuestt),
       decode(e.ktfbuesta, 1, 'ACTIVE', 2, 'EXPIRED', 3, 'UNEXPIRED',
              'UNDEFINED')
from undo$ u, ts$ t, sys.x$ktfbue e, sys.file$ f
where
e.ktfbuesegfno = u.file#
and e.ktfbuesegbno = u.block#
and e.ktfbuesegtsn = u.ts#
and (u.spare1 = 1 or u.spare1 = 2)
and u.status$ != 1
and t.ts# = u.ts#
and e.ktfbuefno = f.relfile#
and u.ts# = f.ts#
and (bitand(t.flags, 16777216) = 0)

View Text - HTML Formatted

SELECT /*+ ORDERED USE_NL(E) USE_NL(F) */ 'SYS'
, U.NAME
, T.NAME
, E.KTFBUEEXTNO
, F.FILE#
, E.KTFBUEBNO
, E.KTFBUEBLKS * T.BLOCKSIZE
, E.KTFBUEBLKS
, E.KTFBUEFNO
, NULLIF(E.KTFBUECTM
, E.KTFBUECTM)
, NULLIF(E.KTFBUESTT
, E.KTFBUESTT)
, DECODE(E.KTFBUESTA
, 1
, 'ACTIVE'
, 2
, 'EXPIRED'
, 3
, 'UNEXPIRED'
, 'UNDEFINED') FROM UNDO$ U
, TS$ T
, SYS.X$KTFBUE E
, SYS.FILE$ F WHERE E.KTFBUESEGFNO = U.FILE# AND E.KTFBUESEGBNO = U.BLOCK# AND E.KTFBUESEGTSN = U.TS# AND (U.SPARE1 = 1 OR U.SPARE1 = 2) AND U.STATUS$ != 1 AND T.TS# = U.TS# AND E.KTFBUEFNO = F.RELFILE# AND U.TS# = F.TS# AND (BITAND(T.FLAGS
, 16777216) = 0)