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