DBA_FREE_SPACE_COALESCED

DBA_FREE_SPACE_COALESCED describes statistics on coalesced space in all tablespaces in the database.

Column	Datatype	NULL	Description
TABLESPACE_NAME	VARCHAR2(30)		Name of the tablespace
TOTAL_EXTENTS	NUMBER		Total number of free extents in the tablespace
EXTENTS_COALESCED	NUMBER		Total number of coalesced free extents in the tablespace
PERCENT_EXTENTS _COALESCED	NUMBER		Percentage of coalesced free extents in the tablespace
TOTAL_BYTES	NUMBER		Total number of free bytes in the tablespace
BYTES_COALESCED	NUMBER		Total number of coalesced free bytes in the tablespace
TOTAL_BLOCKS	NUMBER		Total number of free Oracle blocks in the tablespace
BLOCKS_COALESCED	NUMBER		Total number of coalesced free Oracle blocks in the tablespace
PERCENT_BLOCKS _COALESCED	NUMBER		Percentage of coalesced free Oracle blocks in the tablespace

Note:

1.

select * from DBA_FREE_SPACE_COALESCED;

TABLESPACE_ NAME	TOTAL_ EXTENTS	EXTENTS_ COALESCED	PERCENT_ EXTENTS_ COALESCED	TOTAL_ BYTES	BYTES_ COALESCED	TOTAL_ BLOCKS	BLOCKS_ COALESCED	PERCENT_ BLOCKS_ COALESCED
SYSAUX	13	13	100	510590976	510590976	31164	31164	100
SYSTEM	2	2	100	338624512	338624512	20668	20668	100
UNDO	3	3	100	3145728	3145728	192	192	100
USERS	1	1	100	52232192	52232192	3188	3188	100

Oracle data dictionary views

Oracle dynamic performance views