Databases Reference
In-Depth Information
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:
F
SEGMENT_TYPE
: The type of the segment, such as
INDEX
(PARTITION)
,
or
TABLE
(PARTITION)
F
OWNER
: The owner of the associated segment
F
SEGMENT_NAME
: The name of the associated segment
F
TABLESPACE_NAME
: The name of the tablespace containing the extent
F
BYTES
: The size in bytes
F
BLOCKS
: The size in database blocks
F
FILE_ID
: The file identifier of the file containing the extent
F
EXTENT_ID
: The extent number in the segment
See also
F
The
DBA_DATA_FILES
section in this appendix
DBA_INDEXES
In this view are listed all the indexes in the database. There are the corresponding
ALL_INDEXES
and
USER_INDEXES
, showing, respectively, the indexes which the
current user can access and the indexes the current user owns.
Fields
The most relevant view fields are as follows:
F
OWNER
: The owner of the index
F
INDEX_NAME
: The name of the index
F
TABLE_OWNER
: The owner of the table on which the index is built
F
TABLE_NAME
: The name of the table on which the index is built
F
TABLESPACE_NAME
: The name of the tablespace in which the index is stored
F
STATUS
: This can be
VALID
or
UNUSABLE
