VIEW: SYS.DBA_FREE_SPACE_COALESCED

Source

View Text - Preformatted

select name,total_extents, extents_coalesced,
       extents_coalesced/total_extents*100,total_blocks*c.blocksize,
       blocks_coalesced*c.blocksize, total_blocks, blocks_coalesced,
       blocks_coalesced/total_blocks*100
from DBA_FREE_SPACE_COALESCED_TMP6 a, DBA_FREE_SPACE_COALESCED_TMP5 b,
      sys.ts$ c
where a.ts#=b.ts# and a.ts#=c.ts#
union all
select name, total_extents, total_extents, 100, total_blocks*c.blocksize,
       total_blocks*c.blocksize, total_blocks, total_blocks, 100
from DBA_FREE_SPACE_COALESCED_TMP4 b, sys.ts$ c
where b.ts# = c.ts#

View Text - HTML Formatted

SELECT NAME
, TOTAL_EXTENTS
, EXTENTS_COALESCED
, EXTENTS_COALESCED/TOTAL_EXTENTS*100
, TOTAL_BLOCKS*C.BLOCKSIZE
, BLOCKS_COALESCED*C.BLOCKSIZE
, TOTAL_BLOCKS
, BLOCKS_COALESCED
, BLOCKS_COALESCED/TOTAL_BLOCKS*100 FROM DBA_FREE_SPACE_COALESCED_TMP6 A
, DBA_FREE_SPACE_COALESCED_TMP5 B
, SYS.TS$ C WHERE A.TS#=B.TS#
AND A.TS#=C.TS# UNION ALL SELECT NAME
, TOTAL_EXTENTS
, TOTAL_EXTENTS
, 100
, TOTAL_BLOCKS*C.BLOCKSIZE
, TOTAL_BLOCKS*C.BLOCKSIZE
, TOTAL_BLOCKS
, TOTAL_BLOCKS
, 100 FROM DBA_FREE_SPACE_COALESCED_TMP4 B
, SYS.TS$ C WHERE B.TS# = C.TS#