DBA_EXTENTS

This view returns the extents which build the database files. No extent information is showed for offline datafiles in locally managed tablespaces.

Fields

The most relevant view fields are as follows:

• SEGMENT_TYPE: The type of the segment, such as INDEX (PARTITION), or TABLE (PARTITION)

• OWNER: The owner of the associated segment

• SEGMENT_NAME: The name of the associated segment

• TABLESPACE_NAME: The name of the tablespace containing the extent

• BYTES: The size in bytes

• BLOCKS: The size in database blocks

• FILE_ID: The file identifier of the file containing the extent

• EXTENT_ID: The extent number in the segment

See also

• The DBA_DATA_FILES section in this appendix