Databases Reference
In-Depth Information
F
OBJECT_TYPE
: The object type, such as
TABLE
,
INDEX
, and so on
F
CREATED
: The timestamp for the creation of the object
F
STATUS
: The status of the object, such as
VALID
,
INVALID
, or
N/A
DBA_BLOCKERS
This view returns the session IDs of the sessions holding locks.
Fields
There is only one field in this view, namely,
HOLDING_SESSION
.
See also
F
The
DBA_WAITERS
and
V$SESSION
sections in this appendix
DBA_DATA_FILES
This view returns all datafiles. It's often joined with other views by the
FILE_ID
field,
sometimes named as
FILE#
in other views.
Fields
The most relevant view fields are as follows:
F
FILE_ID
: A unique ID associated with the file
F
FILE_NAME
: The name of the database file
F
TABLESPACE_NAME
: The name of the tablespace to which the file belongs
F
BYTES
: The size in bytes
F
BLOCKS
: The size in database blocks
F
STATUS
: The status of the file, related to its availability; can be
AVAILABLE
or
INVALID
(for example, a file in a dropped tablespace)
F
ONLINE_STATUS
: The online status of the file, can be
SYSOFF
,
SYSTEM
,
OFFLINE
,
ONLINE
, or
RECOVER
See also
F
The
DBA_EXTENTS
,
FILE$
,
V$DATAFILE
,
V$LOGFILE
,
DBA_TEMP_FILES
, and
V$CONTROLFILE
sections in this appendix