V$MANAGED_STANDBY
displays current status information for some Oracle Database processes related to physical standby databases in the Data Guard environment. This view does not persist after an instance shutdown.
Column | Datatype | Description |
---|---|---|
PROCESS |
VARCHAR2(9) |
Type of process whose information is being reported:
|
PID |
NUMBER |
Operating system process identifier of process |
STATUS |
VARCHAR2(12) |
Current process status:
|
CLIENT_PROCESS |
VARCHAR2(8) |
Identifies the corresponding primary database 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 |
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 |