8.64 V$MANAGED_STANDBY
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 |
---|---|---|
|
|
Type of the process whose information is being reported:
|
|
|
Operating system process identifier of the process |
|
|
Current process status:
|
|
|
Identifies the corresponding primary database process:
|
|
|
Operating system process identifier of the client process |
|
|
Database identifier of the primary database |
|
|
Standby redo log group |
|
|
Resetlogs identifier of the archived redo log |
|
|
Archived redo log thread number |
|
|
Archived redo log sequence number |
|
|
Last processed archived redo log block number |
|
|
Count (in 512-byte blocks) of the last write to a redo log, or for a recovery process, the expected final read count |
|
|
Archived redo log delay interval in minutes |
|
|
Total number of standby database agents processing an archived redo log |
|
|
Number of standby database agents actively processing an archived redo log |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
This view is deprecated in Oracle Database 12c Release 2 (12.2.0.1) and may be desupported in a future release. The V$DATAGUARD_PROCESS
view should be used, instead.
See Also: