For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips

image

 
HTML Text

Free Oracle App Server Tips

image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle


 

   
  Oracle Tips by Burleson

Oracle Streams
Chapter 5 -
Apply Process Configuration

Using the create_apply Procedure to Create an Apply Process

Figure 5.5 create_apply procedure parameters

 

The parameters from the procedure are explained as follows:

  • rule_set_name This is the name of the positive rule set for the Apply process. The positive rule set contains the rules that instruct the Apply process to apply events. The rule set should exist.
     

  • message_handler This is a user-defined procedure that processes non-LCR messages in the queue for the Apply process. An existing procedure must be specified.
     

  • ddl_handler This is a user-defined procedure that processes DDL LCRs in the queue for the Apply process. An existing procedure must be specified.
     

  • apply_user: This is the user who applies all DML and DDL changes that satisfy the Apply process rule sets and who runs user-defined Apply handlers.
     

  • apply_tag: This is a binary tag that is added to redo entries generated by the specified Apply process.
     

  • include_dml: If true, this parameter creates a DML rule for DML changes. If false, it does not create a DML rule. NULL is not permitted.
     

  • include_ddl: If true, this parameter creates a DDL rule for DDL changes. If false, it does not create a DDL rule. NULL is not permitted.
     

  • apply_captured: If true, the Apply process applies only the events in a queue that were captured by a Streams Capture process. If false, the Apply process applies only the user-enqueued events in a queue.
     

  • precommit_handler: This is a user-defined procedure that can receive internal commit directives in the queue for the Apply process before they are processed by the Apply process.


The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma
 


For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot.

  
 

 
 
 
 
Oracle performance tuning software
 
 

 

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

 

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544


Email BC: