VIEW: SYS.DBA_LMT_USED_EXTENTS

Source

View Text - Preformatted

select  u.ktfbuesegfno, u.ktfbuesegbno, u.ktfbuesegtsn,
        u.ktfbueextno, u.ktfbuefno, u.ktfbuebno, u.ktfbueblks
from    sys.x$ktfbue u
where   not exists (select * from sys.recyclebin$ rb
                    where u.ktfbuesegtsn = rb.ts#
                      and u.ktfbuesegfno = rb.file#
                      and u.ktfbuesegbno = rb.block#)

View Text - HTML Formatted

SELECT U.KTFBUESEGFNO
, U.KTFBUESEGBNO
, U.KTFBUESEGTSN
, U.KTFBUEEXTNO
, U.KTFBUEFNO
, U.KTFBUEBNO
, U.KTFBUEBLKS FROM SYS.X$KTFBUE U WHERE NOT EXISTS (SELECT *
FROM SYS.RECYCLEBIN$ RB
WHERE U.KTFBUESEGTSN = RB.TS#
AND U.KTFBUESEGFNO = RB.FILE#
AND U.KTFBUESEGBNO = RB.BLOCK#)