7.165 V$DATAGUARD_PROCESS
V$DATAGUARD_PROCESS
displays one row for each Oracle Data Guard process that is currently running.
Column | Datatype | Description |
---|---|---|
|
|
Name of the process whose information is being reported. Some of the possible values include:
|
|
|
Operating system process identifier of the process |
|
|
Indicates which Oracle subsystem created the process. Possible values:
|
|
|
Role of the process. Some of the possible values include:
|
|
|
Timestamp of when the process started or registered for inclusion in this fixed view |
|
|
Timestamp of when the first task of the process was requested |
|
|
Indicates whether the task performed by the process is done ( |
|
|
Current action of the process. Possible values can include:
|
|
|
For RFS and DTS processes, the PID of the process communicating with this process |
|
|
For RFS and DTS processes, the role of the process communicating with this process. Possible values can include:
|
|
|
Group number of the log that the process is operating upon |
|
|
Resetlog ID (branch) of the log that the process is operating upon |
|
|
Thread number that the process is operating upon |
|
|
Sequence number that the process is operating upon |
|
|
Starting block number that the process is operating upon |
|
|
Number of blocks that the process is operating upon |
|
|
Archived redo log delay interval in minutes |
|
|
Destination ID that the process is currently operating upon |
|
|
Mask of all destination IDs that the process will operate upon, where:
and so on. |
|
|
Database ID of the redo that the process is operating upon |
|
|
Data Guard ID that the process must communicate with |
|
|
Instance number that the process must communicate with at the specified DGID |
|
|
Indicates the method by which the process has been requested to stop:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
Oracle recommends that you use this view instead of V$MANAGED_STANDBY
.