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 . |