Dbvisit Replicate Profile 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:

Mine

1. Shutdown the Mine process
2. Edit the *-MINE.ddc DDC file.

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

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

4. Restart the Mine process
5. Wait for a few log switches.
6. Zip and upload the resulting file to Dbvisit Support

7. Turn off the profiling with by removing the profiler command OR adding a comment in front of the line in the DDC file:

   # memory_set PROFILER /home/oracle/..../prof_%S.%E

8. Restart the Mine process

Apply

1. Shutdown the Apply process
2. Edit the *-APPLY.ddc DDC file.

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

   memory_set PROFILER /home/oracle/..../prof_%S.%E
   memory_set _THREADED_OCI NO

4. Restart the Apply process
5. Wait for a few log switches.
6. Zip and upload the resulting file to Dbvisit Support

7. Turn off the profiling with by removing the profiler command OR adding a comment in front of the line in the DDC file:

   # memory_set PROFILER /home/oracle/..../prof_%S.%E
   # memory_set _THREADED_OCI NO

8. Restart the Apply process

set _SUBPROFILER=YES

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