Dynamic Performance (V$) Views, 6 of 238

V$ARCHIVE

This view contains information on redo log files in need of archiving. Each row provides 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 only for compatibility reasons. The value of this column is always equal to the value in `ISCURRENT`.
`FIRST_CHANGE#`	`NUMBER`	First SCN stored in the current log