v$streams_apply_coordinator

The above SQL statements help to monitor the overall apply activity.

v$streams_apply_reader

This view displays information about each Apply reader. The Apply reader for an Apply process is a process which dequeues messages from the queue, computes message dependencies, builds transactions, and passes the transactions on to the Apply process coordinator in commit order for assignment to the Apply servers.

The following SQL statement shows full details about the Apply server reader processes. This SQL outputs a multi line format display to improve the readability of the details.

COL FROM_STREAMS_APPLY_READER format a60

select 'Session SID           : ' || SID || chr(10) ||
'APPLY Name            : ' || APPLY_NAME|| chr(10) ||
'Current State         : ' || STATE || chr(10) ||
'TOT MSGs Dequed       : ' || TOTAL_MESSAGES_DEQUEUED || chr(10) ||
'Time last msg received: ' || to_char(DEQUEUE_TIME, 'YY-MM-DD HH24:MI') 
|| chr(10) ||
'Last DeQued MSG  NUM  : ' || DEQUEUED_MESSAGE_NUMBER || chr(10) ||
'CRT-Time at SRCDB of Last MSG : ' ||
to_char(DEQUEUED_MESSAGE_CREATE_TIME, 'YY-MM-DD HH24:MI')||chr(10)|| 
'SGA Used so far       : ' || SGA_USED || chr(10) ||
'Last browse SCN       : ' || LAST_BROWSE_NUM || chr(10) ||
'Oldest SCN            : ' || OLDEST_SCN_NUM
FROM_STREAMS_APPLY_READER
from V$STREAMS_APPLY_READER
/