V$STREAMS_APPLY_READER

V$STREAMS_APPLY_READER displays information about the apply reader. The apply reader is a process which reads (dequeues) messages from the queue, computes message dependencies, builds transactions, and passes the transactions on to the coordinator in commit order for assignment to the apply servers.

Column	Datatype	Description
SID	NUMBER	Session ID of the apply server
SERIAL#	NUMBER	Serial number of the current session
APPLY#	NUMBER	Apply process number. An apply process is an Oracle background process, prefixed by AP.
APPLY_NAME	VARCHAR2(30)	Name of the apply process
STATE	VARCHAR2(17)	State of the reader (IDLE, DEQUEUE MESSAGES, SCHEDULE MESSAGES)
TOTAL_MESSAGES_DEQUEUED	NUMBER	Total number of messages read
DEQUEUE_TIME	DATE	Time last message was received
DEQUEUED_MESSAGE_NUMBER	NUMBER	Number of the last message received
DEQUEUED_MESSAGE_CREATE_TIME	DATE	Creation time of the last message received
SGA_USED	NUMBER	Amount of SGA memory used
ELAPSED_DEQUEUE_TIME	NUMBER	time elapsed dequeuing messages
ELAPSED_SCHEDULE_TIME	NUMBER	Time elapsed scheduling messages