V$LOG

This view displays information on log files from the control file.

Fields

The most relevant view fields are:

• GROUP#: The log group number

• THREAD#: The log thread number

• SEQUENCE#: The log sequence number

• BYTES: The size of the log in bytes

• BLOCKSIZE: The block size of the log file

• MEMBERS: The number of members in the log group

• ARCHIVED: The archive status (YES or NO)

• STATUS: The log status; it can be UNUSED, CURRENT, ACTIVE, CLEARING, CLEARING_CURRENT, or INACTIVE

• FIRST_CHANGE#: The lowest system change number stored in the log

• FIRST_TIME: The time of the first system change number in the log

See also

• The V$LOG_HISTORY and V$LOGFILE sections in this appendix