9.139 V$XSTREAM_APPLY_RECEIVER
V$XSTREAM_APPLY_RECEIVER
displays information about the message receiver of the apply process. The values are reset to zero when the database (or instance in an Oracle Real Application Clusters (Oracle RAC) environment) restarts, when apply migrates to another instance, or when the XStream process is stopped.
Column | Datatype | Description |
---|---|---|
|
|
Session ID of the apply receiver |
|
|
Serial number of the apply receiver |
|
|
Name of the apply process |
|
|
Startup time of the apply process |
|
|
Name of the source database |
|
|
Acknowledgement SCN of the messages received by the receiver |
|
|
Last received message |
|
|
Total number of messages received |
|
|
Number of available messages |
|
|
State of the apply receiver:
|
|
|
Last received message position |
|
|
Acknowledgement position of the messages received by the receiver. Corresponds to |
|
|
The ID of the container to which the data pertains. Possible values include:
|