Static Data Dictionary Views, 252 of 666

DBA_FREE_SPACE

DBA_FREE_SPACE describes the free extents in all tablespaces in the database.

USER_FREE_SPACE describes the free extents in the tablespaces accessible to the current user.

Column	Datatype	Description
`TABLESPACE_NAME`	`VARCHAR2(30)`	Name of the tablespace containing the extent
`FILE_ID`	`NUMBER`	File identifier 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 file number of the file containing the extent

See Also:

"USER_FREE_SPACE"