Oracle Tips by Burleson

dba_free_space

DBA_FREE_SPACE
Free extents in all tablespaces
------------------------------------------------------------------------------------
TABLESPACE_NAME 		VARCHAR2 	Name of the tablespace containing the extent
FILE_ID 			NUMBER 	ID number of the file containing the extent
BLOCK_ID 			NUMBER 	Starting block number of the extent
BYTES 			NUMBER 	Size of the extent in bytes
BLOCKS 			NUMBER 	Size of the extent in ORACLE blocks
RELATIVE_FNO 		NUMBER 	Relative number of the file containing the extent


DBA_FREE_SPACE_COALESCED
Statistics on Coalesced Space in Tablespaces
------------------------------------------------------------------------------------
TABLESPACE_NAME 		VARCHAR2 	Name of Tablespace
TOTAL_EXTENTS 		NUMBER 	Total Number of Free Extents in Tablespace
EXTENTS_COALESCED 		NUMBER 	Total Number of Coalesced Free Extents in Tablespace
PERCENT_EXTENTS_COALESCED 	NUMBER 	Percentage of Coalesced Free Extents in Tablespace
TOTAL_BYTES 		NUMBER 	Total Number of Free Bytes in Tablespace
BYTES_COALESCED 		NUMBER 	Total Number of Coalesced Free Bytes in Tablespace
TOTAL_BLOCKS 		NUMBER 	Total Number of Free Oracle Blocks in Tablespace
BLOCKS_COALESCED 		NUMBER 	Total Number of Coalesced Free Oracle Blocks in Tablespace
PERCENT_BLOCKS_COALESCED 	NUMBER 	Percentage of Coalesced Free Oracle Blocks in Tablespace