Improve performance with Oracle Streams

Tips: Improve performance with Oracle StreamsSource Database1. set capture process parallelismSQL> exec dbms_capture_adm.set_parameter (capture_name => ‘name’,parameter => ‘parallelism’,value => 16);NOTE: Default value is 1.Target Database2. set apply process parallelismSQL> exec dbms_apply_adm.set_parameter (apply_name => ‘name’,parameter => ‘parallelism’,value => 16);3. Increase SHARED_POOL_SIZE (prior 10g) & STREAM_POOL_SIZE (10g later)4. Increase the SDU (Session data unit) in a WAN (wide area network)5. Implement “heartbeat” table for monitor changes on target database6. Increase “log_archive_max_processes” parameter5. Use Frequent Commit Interval in Source database.