V$GG_APPLY_RECEIVER displays information about the message receiver of the Replicat process. The values are reset to zero when the database (or instance in an Oracle Real Application Clusters (Oracle RAC) environment) restarts and when the Replicat 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
acknowledgment 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 memory
Waiting for apply to read
Waiting for message from Replicat
Waiting for Replicat flush request to complete
Waiting for Replicat commit to complete
Last received message position
acknowledgment 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 (22.214.171.124).