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
`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`	Acknowledgement SCN 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(44)`	State of the apply receiver: Initializing Sending unapplied txns Waiting for message from client Waiting for LCR from client Receiving LCRs Evaluating rules Enqueueing LCRS Waiting for memory Waiting for apply to read Waiting for client flush request to complete Waiting for client commit to complete
`LAST_RECEIVED_MSG_POSITION`	`RAW(64)`	Last received message position
`ACKNOWLEDGEMENT_POSITION`	`RAW(64)`	Acknowledgement 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).