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