v$streams_apply_server

Some of the fields that are useful in the monitoring of the Apply activity are as follows:

• server_id – The parallel execution server number of the Apply server.
   

• total_assigned – The total number of transactions assigned to the Apply server since the Apply process was last started.
   

• total_messages_applied – The total number of messages applied by this Apply server since the Apply process was last started.
   

• applied_message_number – The number of the last message applied.
   

• elapsed_dequeue_time – The time elapsed, in hundredths of a second, during the dequeuing of messages since the Apply process was last started.
   

• elapsed_apply_time – The time elapsed, in hundredths of a second, during the applying of messages since the Apply process was last started.

The following SQL statement shows some useful statistics related to messages applied:

select SID, APPLY_NAME, TOTAL_ASSIGNED, TOTAL_ADMIN, TOTAL_MESSAGES_APPLIED,ELAPSED_DEQUEUE_TIME ,
ELAPSED_APPLY_TIME from V$STREAMS_APPLY_SERVER
/