V$ARCHIVE_PROCESSES: Archive Process



Share this article :

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.

Related posts

V$INSTANCE: Display Oracle Database & Instance State
ORA-27101: shared memory realm does not exist
Specifying SCOPE in Parameter for BOTH, Memory & SPFILE
ORA-16038: log xx sequence# xxxxx cannot be archived
© 2017 ITsiti. All Rights Reserved
Powered by KEEM