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 |
---|---|---|
|
|
Log file group number |
|
|
Log file thread number |
|
|
Log file sequence number |
|
|
This is the current online redo log |
|
|
This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in |
|
|
First SCN stored in the current log |
|
|
The ID of the container to which the data pertains. Possible values include:
|