Dynamic Performance (V$) Views, 5 of 179

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

CURRENT

VARCHAR2(3)

Archive log currently in use

FIRST_CHANGE#

NUMBER

First SCN stored in the current log

m

Column	Datatype	Description
`GROUP#`	`NUMBER`	Log file group number
`THREAD#`	`NUMBER`	Log file thread number
`SEQUENCE#`	`NUMBER`	Log file sequence number
`CURRENT`	`VARCHAR2(3)`	Archive log currently in use
`FIRST_CHANGE#`	`NUMBER`	First SCN stored in the current log