Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$ARCHIVE

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:

"V$LOG"

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