DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_LMT_FREE_SPACE

Object Details
Object Name: CDB_LMT_FREE_SPACE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Free extents in all locally managed tablespaces in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLESPACE_ID NUMBER

ID 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
BLOCKS NUMBER

Size of the extent in blocks
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TABLESPACE_ID
,      FILE_ID
,      BLOCK_ID
,      BLOCKS
,      CON_ID
FROM SYS.CDB_LMT_FREE_SPACE;

Dependencies

[top of page]

SYS.CDB_LMT_FREE_SPACE does not reference any database object

SYS.CDB_LMT_FREE_SPACE is referenced by following:

SchemaPUBLIC
SynonymCDB_LMT_FREE_SPACE