Coordinator Process:

The following is the output:

                   Total      Total     Total  Total       Total
                  Trans      Trans     Apply  Trans Being Trans
Apply Process Name Received   Applied   Errors Applied     Ignored
------------------ ---------  --------- ------ ----------- ---------
LN1_APPLY          30          30        0      0           0

Apply Servers:

Each Apply server is a parallel execution server. The Apply servers apply LCRs to database objects as DML or DDL statements or pass the LCRs to the appropriate handlers. For non-LCR messages, the Apply servers pass the events to the message handler. If an Apply server encounters an error, it then tries to resolve the error with a user-specified conflict handler or error handler. If an Apply server cannot resolve an error, it rolls back the transaction and places the entire transaction, including all of its events, in the error queue. This is, in fact, the end point of the apply mechanism. At this stage, either the transactions have to be executed, also called applied, or they are moved to the error queue.

When an Apply server commits a completed transaction, this transaction is treated as applied. When an Apply server places a transaction in the error queue and commits, this transaction is also treated as applied.

The STATE of an Apply server describes what the Apply server is doing currently. The STATE of each Apply server for an Apply process can be seen by querying the v$streams_apply_server dynamic performance view. The following Apply server states are possible: