The following is the output:
Total Total Total
Apply Trans Being Trans
Apply Process Name Received Applied
Errors Applied Ignored
------------------ --------- ---------
------ ----------- ---------
LN1_APPLY 30 30
0 0 0
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: