PROCESS
|
VARCHAR2(9)
|
Type of the process whose information is being reported:
-
RFS - Remote file server
-
MRP0 - Detached recovery server process
-
MR(fg) - Foreground recovery session
-
ARCH - Archiver process
-
FGRD
-
LGWR
-
RFS(FAL)
-
RFS(NEXP)
-
LNS - ASYNC Redo Transport process
|
PID
|
VARCHAR2(24)
|
Operating system process identifier of the process
|
STATUS
|
VARCHAR2(12)
|
Current process status:
-
UNUSED - No active process
-
ALLOCATED - Process is active but not currently connected to a primary database
-
CONNECTED - Network connection established to a primary database
-
ATTACHED - Process is actively attached and communicating to a primary database
-
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 redo data to the archived redo log
-
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:
-
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
|
RESETLOG_ID
|
NUMBER
|
Resetlogs identifier of the archived redo log
|
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
|
Count (in 512-byte blocks) of the last write to a redo log, or for a recovery process, the expected final read count
|
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
|
CON_ID
|
NUMBER
|
The ID of the container to which the data pertains. Possible values include:
-
0 : This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
-
1 : This value is used for rows containing data that pertain to only the root
-
n: Where n is the applicable container ID for the rows containing data
|