Optimize Dbvisit Replicate performance (increase MINE/APPLY speed)

Problem Description

This article explains how to optimise the performance of Dbvisit Replicate. 

Solution

Three simple strategies for improving the processing speed of Dbvisit Replicate include:

  1. Fast disks: use these for the PLOG files in particular.

  2. Ensure that there are no network issues. Intermittent issues can be detected as dropped connections in the Dbvisit Replicate MINE/APPLY log files.

  3. Give the APPLY process more memory.

For a more comprehensive list of suggestions for optimizing Dbvisit Replicate performance please see the following:

https://dbvisit.atlassian.net/wiki/display/ugd7/Optimizing+and+improving+performance (Replicate 2.7)

https://dbvisit.atlassian.net/wiki/display/ugd8/Optimizing+and+improving+performance (Replicate 2.8)

Mike Donovan September 12, 2014 11:47