Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-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

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