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

Home Home
Oracle Monitoring
Growth Monitoring
Emergency DBA Support
Installs & Upgrades
Oracle Migration
Oracle Support Plan
Oracle SQL Tuning
Oracle Performance Tuning

 Our Remote DBA Clients

 

Free Oracle Tips


 
HTML Text

Free Oracle App Server Tips


 
HTML Text

 

   
  Oracle Tips by Burleson

Oracle Streams
Chapter 4 - Capture and Propagate Configuration

Setting Up the Capture Parameters

message_limit

Imposes limit on the number of messages. Capture process stops after capturing the specified number of messages. If set to INFINITE, the Capture process continues to run regardless of the number of messages captured. The default is INFINITE.

parallelism

Sets the number of parallel execution servers that may concurrently mine the redo log.

startup_seconds

The maximum number of seconds to wait for another instantiation of the same Capture process to finish.

time_limit

The Capture process stops as soon as possible after the specified number of seconds since it started. The default is INFINITE.

trace_level

Set this parameter only under the guidance of Oracle Support Services.

write_alert_log

If set to Y, the Capture process writes a message to the alert log on exit. The message specifies the reason the Capture process stopped. The default is INFINITE.

Table 4.1 List of Parameters that can be set in the Capture process


The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma
 


    Need an Oracle Health Check?

Does your boss blame you for an Oracle performance problem? 
Need to prove that your database is properly optimized?

BC Oracle performance guru's can quickly verify every aspect of your Oracle database and provide a complete certification that your database is fully optimized.

Burleson Oracle consulting & training



 

 

WISE Oracle monitoring software
 

 

Oracle forum for DBA 

 

Rampant TechPress Oracle book publisher

image 

  

 

E-mail us for BC Oracle support:   

Copyright © 1996 -  2012 by Burleson Enterprises. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.