V$XSTREAM_APPLY

9.137 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(128)`	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.
`CON_ID`	`NUMBER`	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