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.
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:
Sending unapplied txns
Waiting for message from client
Waiting for LCR from client
Waiting for memory
Waiting for apply to read
Waiting for client flush request to complete
Waiting for client commit to complete
Last received message position
Acknowledgement position of the messages received by the receiver. Corresponds to ACKNOWLEDGEMENT, except the value is in position rather than SCN.
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