DBA_FREE_SPACE

DBA_FREE_SPACE lists the free extents in all tablespaces.

Related View

• USER_FREE_SPACE lists the free extents in tablespaces accessible to the current user.

  Column	Datatype	NULL	Description
  TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the extent
  FILE_ID	NUMBER	NOT NULL	ID number of the file containing the extent
  BLOCK_ID	NUMBER	NOT NULL	Starting block number of the extent
  BYTES	NUMBER		Size of the extent in bytes
  BLOCKS	NUMBER	NOT NULL	Size of the extent in Oracle blocks
  RELATIVE_FNO	NUMBER	NOT NULL	Relative file number of the first extent block