Databases Reference
In-Depth Information
V$LOGFILE
This view contains information about redo log files.
Fields
The most relevant view fields are as follows:
F
GROUP#
: The redo log group identification number
F
STATUS
: The status of the log member; it can be
INVALID
,
STALE
,
DELETED
,
or
NULL
when the file is in use
F
TYPE
: The type of the log file, it can be
ONLINE
or
STANDBY
F
MEMBER
: The redo log member name
F
IS_RECOVERY_DEST_FILE
: This indicates whether the file was created in
the fast recovery area (
YES
) or not (
NO
)
See also
F
The
V$LOG
and
V$LOG_HISTORY
recipes in this appendix
V$MYSTAT
This view contains statistics on the current session.
Fields
The most relevant view fields are as follows:
F
SID
: The session identifier for the current session
F
STATISTIC#
: The number of the
STATISTIC
F
VALUE
: The value of the
STATISTIC
See also
F
The
V$STATNAME
,
V$SESSTAT
, and
V$SYSSTAT
sections in this appendix