Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Oracle Streams
Chapter 5 -
Apply Process Configuration

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:

The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.