PROCESS
|
VARCHAR2(7)
|
Type of process whose information is being reported. Possible values are:
RFS - remote file server
MRP0 - detached recovery server process
MR(fg) - foreground recovery session
|
PID
|
NUMBER
|
Operating system process identifier of process
|
STATUS
|
VARCHAR2(12)
|
Current process status. Possible values are:
UNUSED - no active process
ALLOCATED - process is active but not currently connected to a primary database client
CONNECTED - network connection established to a primary database client
ATTACHED - process is actively attached and communicating to a primary database client
IDLE - process is not performing any activities
ERROR - process has failed
OPENING - process is opening the archived redo log
CLOSING - process has completed archival and is closing the archived redo log
WRITING - process is actively writing archived redo log data
RECEIVING - process is receiving network communication
ANNOUNCING - process is announcing the existence of a potential dependent archived redo log
REGISTERING - process is registering the existence of a completed dependent archived redo log
WAIT_FOR_LOG - process is waiting for the archived redo log to be completed
WAIT_FOR_GAP - process is waiting for the archive gap to be resolved
APPLYING_LOG - process is actively applying the archived redo log to the standby database
|
CLIENT_PROCESS
|
VARCHAR2(8)
|
Identifies the corresponding primary database process. Possible values are:
ARCHIVAL - foreground (manual) archival process (SQL)
ARCH - background ARC n process
LGWR - background LGWR process
|
CLIENT_PID
|
VARCHAR2(40)
|
Operating system process identifier of the client process
|
CLIENT_DBID
|
VARCHAR2(40)
|
Database identifier of the primary database
|
GROUP#
|
VARCHAR2(40)
|
Standby redo log group
|
THREAD#
|
NUMBER
|
Archived redo log thread number
|
SEQUENCE#
|
NUMBER
|
Archived redo log sequence number
|
BLOCK#
|
NUMBER
|
Last processed archived redo log block number
|
BLOCKS
|
NUMBER
|
Size of the archived redo log in 512-byte blocks
|
DELAY_MINS
|
NUMBER
|
Archived redo log delay interval in minutes
|
KNOWN_AGENTS
|
NUMBER
|
Total number of standby database agents processing an archived redo log
|
ACTIVE_AGENTS
|
NUMBER
|
Number of standby database agents actively processing an archived redo log
|