Dbvisit Replicate Performance Statistics

Dbvisit Replicate can collect profiling or performance statistics information which will assist Dbvisit support to diagnose performance issues.

Profiling can be turned on for either Mine, Apply or both.

To turn on profiling:

1. Edit the relevant DDC file, *-MINE.ddc for the Mine process and *-APPLY.ddc for the Apply process.

2. Add the following line to the DDC file (give full path name):  

   SET PROFILER /home/oracle/..../prof_%S.%E

3. Restart the process (mine or apply).
4. Wait for a few log switches.
5. Zip and upload the resulting file to Dbvisit Support

6. Turn off the profiling with command: 

   SET PROFILER OFF

7. Restart the process (mine or apply).

Please see Configuration Variable Reference for more information on setting PROFILER.