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. |
Oracle data dictionary views
Last updated: 2009-11-24 Tuesday |
No comments:
Post a Comment