Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_EXTENTS
describes the extents comprising the segments in all tablespaces in the database.
USER_EXTENTS
describes the extents comprising the segments owned by the current user's objects. This view does not display the OWNER
, FILE_ID
, BLOCK_ID
, or RELATIVE_FNO
columns.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the segment associated with the extent | |
SEGMENT_NAME |
VARCHAR2(81) |
Name of the segment associated with the extent | |
PARTITION_NAME |
VARCHAR2(30) |
Object Partition Name (Set to NULL for non-partitioned objects) | |
SEGMENT_TYPE |
VARCHAR2(18) |
Type of the segment: INDEX PARTITION, TABLE PARTITION | |
TABLESPACE_NAME |
VARCHAR2(30) |
Name of the tablespace containing the extent | |
EXTENT_ID |
NUMBER |
Extent number in the segment | |
FILE_ID |
NUMBER |
File identifier number of the file containing the extent | |
BLOCK_ID |
NUMBER |
Starting block number of the extent | |
BYTES |
NUMBER |
Size of the extent in bytes | |
BLOCKS |
NUMBER |
Size of the extent in Oracle blocks | |
RELATIVE_FNO |
NUMBER |
Relative file number of the first extent block |