Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

DBA_LMT_USED_EXTENTS

DBA_LMT_USED_EXTENTS describes the extents comprising the segments in all locally managed tablespaces in the database.

Column Datatype NULL Description

SEGMENT_FILEID

NUMBER

NOT NULL

File number of the segment header of the extent

SEGMENT_BLOCK

NUMBER

NOT NULL

Block number of the segment header of the extent

TABLESPACE_ID

NUMBER

NOT NULL

Identifier number of the tablespace containing the extent

EXTENT_ID

NUMBER

NOT NULL

Extent number in the segment

FILEID

NUMBER

NOT NULL

File identifier number of the file containing the extent

BLOCK

NUMBER

NOT NULL

Starting block number of the extent

LENGTH

NUMBER

NOT NULL

Number of blocks in the extent