VIEW: SYS.DBA_FREE_SPACE_COALESCED_TMP2

Source

View Text - Preformatted

select ts#, count(*), sum(length)
    from sys.fet$
  group by ts#
union all
  select u.ts#, count(*), sum(u.length)
    from sys.uet$ u, sys.ts$ ts, sys.recyclebin$ rb
  where ts.ts# = u.ts#
    and u.ts# = rb.ts#
    and u.segfile# = rb.file#
    and u.segblock# = rb.block#
    and ts.bitmapped = 0
  group by u.ts#

View Text - HTML Formatted

SELECT TS#
, COUNT(*)
, SUM(LENGTH)
FROM SYS.FET$ GROUP BY TS# UNION ALL SELECT U.TS#
, COUNT(*)
, SUM(U.LENGTH)
FROM SYS.UET$ U
, SYS.TS$ TS
, SYS.RECYCLEBIN$ RB
WHERE TS.TS# = U.TS#
AND U.TS# = RB.TS#
AND U.SEGFILE# = RB.FILE#
AND U.SEGBLOCK# = RB.BLOCK#
AND TS.BITMAPPED = 0 GROUP BY U.TS#