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