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

VIEW: SYS.DBA_LMT_USED_EXTENTS

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

All extents in the locally managed tablespaces

[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
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
FROM SYS.DBA_LMT_USED_EXTENTS;

Dependencies

[top of page]

SYS.DBA_LMT_USED_EXTENTS references the following:

SchemaSYS
TableRECYCLEBIN$
SYS.DBA_LMT_USED_EXTENTS is referenced by following:

SchemaPUBLIC
SynonymDBA_LMT_USED_EXTENTS