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

Home
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


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

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:

www.oracle-script.com

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.