Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


V$ARCHIVE displays information about redo log files in need of archiving. Each row displays information for one thread. This information is also available in V$LOG. Oracle recommends that you use V$LOG.

See Also:

Column Datatype Description
GROUP# NUMBER Log file group number
THREAD# NUMBER Log file thread number
SEQUENCE# NUMBER Log file sequence number
ISCURRENT VARCHAR2(3) This is the current online redo log
CURRENT VARCHAR2(3) This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in ISCURRENT.
FIRST_CHANGE# NUMBER First SCN stored in the current log