Databases Reference
In-Depth Information
F
STATUS
: The datafile status; can be
OFFLINE
,
ONLINE
,
SYSTEM
,
RECOVER
, or
SYSOFF
F
ENABLED
: This describes if the file is accessible; the possible values are
DISABLED
,
READ
ONLY
,
READ
WRITE
, or
UNKNOWN
F
BYTES
: The datafile size in bytes
F
BLOCKS
: The datafile size in database blocks
See also
F
The
V$FILESTAT
,
V$LOGFILE
, and
V$TEMPFILE
sections in this appendix
V$DB_CACHE_ADVICE
This view contains predictions on the number of physical reads obtained when varying
the cache size.
Fields
The most relevant view fields are as follows:
F
ID
: The buffer pool identifier
F
NAME
: The buffer pool name
F
BLOCK_SIZE
: The size of the database block for this pool
F
SIZE_FOR_ESTIMATE
: The cache size for prediction in megabytes
F
BUFFERS_FOR_ESTIMATE
: The cache size for prediction in number of buffers
F
ESTD_PHYSICAL_READS
: The estimated number of physical reads for the cache
size evaluated
F
ESTD_PHYSICAL_READ_FACTOR
: The estimated physical read factor for the cache
size evaluated, a ratio to the number of reads in the cache
See also
F
The
V$BUFFER_POOL_STATISTICS
and
V$DB_OBJECT_CACHE
sections in
this appendix