Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-11
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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.
ROLESFoot 1  VARCHAR2(36) The list of roles assigned to the archive process.

The roles include: HEART_BEAT, NO_FAL, NO_SRL, CLEAR_LOGS


Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.4)