VIEW: SYS.DBA_FREE_SPACE_COALESCED_TMP3

Source

View Text - Preformatted

select /*+ ordered */ ktfbfetsn, count(*), sum(ktfbfeblks)
    from sys.x$ktfbfe
  group by ktfbfetsn
union all
  select /*+ ordered use_nl(e) */ ktfbuesegtsn, count(*), sum(ktfbueblks)
    from sys.ts$ ts , sys.recyclebin$ rb, sys.x$ktfbue e
    where ts.ts# = e.ktfbuesegtsn
      and e.ktfbuesegtsn = rb.ts#
      and e.ktfbuesegfno = rb.file#
      and e.ktfbuesegbno = rb.block#
      and ts.bitmapped <> 0
      and ts.online$ in (1,4)
      and ts.contents$ = 0
  group by ktfbuesegtsn

View Text - HTML Formatted

SELECT /*+ ORDERED */ KTFBFETSN
, COUNT(*)
, SUM(KTFBFEBLKS)
FROM SYS.X$KTFBFE GROUP BY KTFBFETSN UNION ALL SELECT /*+ ORDERED USE_NL(E) */ KTFBUESEGTSN
, COUNT(*)
, SUM(KTFBUEBLKS)
FROM SYS.TS$ TS
, SYS.RECYCLEBIN$ RB
, SYS.X$KTFBUE E
WHERE TS.TS# = E.KTFBUESEGTSN
AND E.KTFBUESEGTSN = RB.TS#
AND E.KTFBUESEGFNO = RB.FILE#
AND E.KTFBUESEGBNO = RB.BLOCK#
AND TS.BITMAPPED <> 0
AND TS.ONLINE$ IN (1
, 4)
AND TS.CONTENTS$ = 0 GROUP BY KTFBUESEGTSN