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.
This view is available starting with Oracle Database 11g Release 2 (188.8.131.52).