| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
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.
| 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 |
