Databases Reference
In-Depth Information
See also
F
The
V$DB_CACHE_ADVICE
section to get advice in sizing the buffer pools
V$CONTROLFILE
This lists the names of the control files.
Fields
The most relevant view fields are as follows:
F
STATUS
: This is null if the name can be determined,
INVALID
otherwise
F
NAME
: The control filename
F
IS_RECOVERY_DEST_FILE
: This indicates whether the control file was
created in the fast recovery area (
YES
) or not (
NO
)
F
BLOCK_SIZE
: The control file block size
F
FILE_SIZE_BLKS
: The control file size in blocks
See also
F
The
V$DATAFILE
,
DBA_TEMP_FILES
,
V$FILESTAT
,
V$LOGFILE
, and
V$TEMPFILE
sections in this appendix
V$DATAFILE
This lists datafile information taken from the control file.
Fields
The most relevant view fields are as follows:
F
FILE#
: The file identification number
F
NAME
: The filename
F
CREATION_TIME
: The timestamp of file creation
F
TS#
: The tablespace identification number