V$ARCHIVE_PROCESSES displays the state of the various ARCH processes for the instance.
| Column | Datatype | Description |
|---|---|---|
PROCESS |
NUMBER |
Identifier for the ARCH process for the instance, numbered from 0-9 |
STATUS |
VARCHAR2(10) |
Status of the ARCH process, displayed as a keyword. Possible values are: STOPPED, SCHEDULED, STARTING, ACTIVE, STOPPING, and TERMINATED. |
LOG_SEQUENCE |
NUMBER |
This is the online redo log sequence number currently being archived, if STATE="BUSY" |
STATE |
VARCHAR2(4) |
This is the current state of the ARCH process, displayed as a keyword. Possible keywords are IDLE or BUSY. |