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

VIEW: SYS.CDB_LMT_USED_EXTENTS

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

All extents in the locally managed tablespaces in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEGMENT_FILEID NUMBER

File number of segment header of the extent
SEGMENT_BLOCK NUMBER

Block number of segment header of the extent
TABLESPACE_ID NUMBER

ID of the tablespace containing the extent
EXTENT_ID NUMBER

Extent number in the segment
FILEID NUMBER

File Number of the extent
BLOCK NUMBER

Starting block number of the extent
LENGTH NUMBER

Number of blocks in the extent
CON_ID NUMBER

container id
Query Text

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


SELECT SEGMENT_FILEID
,      SEGMENT_BLOCK
,      TABLESPACE_ID
,      EXTENT_ID
,      FILEID
,      BLOCK
,      LENGTH
,      CON_ID
FROM SYS.CDB_LMT_USED_EXTENTS;

Dependencies

[top of page]

SYS.CDB_LMT_USED_EXTENTS does not reference any database object

SYS.CDB_LMT_USED_EXTENTS is referenced by following:

SchemaPUBLIC
SynonymCDB_LMT_USED_EXTENTS