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 ARCn 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