OracleDBA_EXTENTS view and DBA_SEGMENTS View

DBA_EXTENDS describes the extended information of all tablespace segments in the database. When using DBA_EXTENDS, make sure that the corresponding data file is in the online state. Otherwise, no response can be returned.

DBA_EXTENDS describes the extended information of all tablespace segments in the database. When using DBA_EXTENDS, make sure that the corresponding data file is in the online state. Otherwise, no response can be returned.

Slave --------------------------------------------------------------------------------------------------------------------------------

DBA_SEGMENTS describes the storage allocated for all segments in the database.

Related View

USER_SEGMENTS describes the storage allocated for the segments owned by the current user's objects. This view does not display the OWNER, HEADER_FILE, HEADER_BLOCK, or RELATIVE_FNO columns.

The DBA_SEGMENTS view describes the storage and allocation of all segments in the database.

The segment contains multiple expansion zones. The expansion zone is the bottom-layer view visible to data-related users. Through these two views, we can know the tablespace where a record is located, data File number and partition. You can also know the size and extended area information of each storage segment.