Oracle Database 11gR2 Performance Tuning Cookbook

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