Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$ARCHIVE_PROCESSES

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.