This view returns the extents which build the database files. No extent information is showed for offline datafiles in locally managed tablespaces.
The most relevant view fields are as follows:
SEGMENT_TYPE
: The type of the segment, such asINDEX (PARTITION)
, orTABLE (PARTITION)
OWNER
: The owner of the associated segmentSEGMENT_NAME
: The name of the associated segmentTABLESPACE_NAME
: The name of the tablespace containing the extentBYTES
: The size in bytesBLOCKS
: The size in database blocksFILE_ID
: The file identifier of the file containing the extentEXTENT_ID
: The extent number in the segment