V$GG_APPLY_RECEIVER

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..

Column	Datatype	Description
`SID`	`NUMBER`	Session ID of the apply receiver
`SERIAL#`	`NUMBER`	Serial number of the apply receiver
`APPLY_NAME`	`VARCHAR2(30)`	Name of the apply process
`STARTUP_TIME`	`DATE`	Startup time of the apply process
`SOURCE_DATABASE_NAME`	`VARCHAR2(128)`	Name of the source database
`ACKNOWLEDGEMENT`	`NUMBER`	acknowledgment of the messages received by the receiver
`LAST_RECEIVED_MSG`	`NUMBER`	Last received message
`TOTAL_MESSAGES_RECEIVED`	`NUMBER`	Total number of messages received
`TOTAL_AVAILABLE_MESSAGES`	`NUMBER`	Number of available messages
`STATE`	`VARCHAR2(46)`	State of the apply receiver: Initializing Sending unapplied txns Waiting for message from client Receiving LCRs Evaluating rules Enqueueing LCRS 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_MSG_POSITION`	`VARCHAR2(64)`	Last received message position
`ACKNOWLEDGEMENT_POSITION`	`VARCHAR2(64)`	acknowledgment position of the messages received by the receiver. Corresponds to `ACKNOWLEDGEMENT`, except the value is in position rather than SCN.

Note:

This view is available starting with Oracle Database 11g Release 2 (11.2.0.4).