Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

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):  

    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 command: 

    SET PROFILER OFF
  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):  

    SET PROFILER /home/oracle/..../prof_%S.%E
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 command:

    SET PROFILER OFF
set _THREADED_OCI YES

  8. Restart the Apply process

Only set " _THREADED_OCI YES" if it was previously set to YES.

Check this with "show _THREADED_OCI" prior to step 1

In some cases, sub profiling can also be enabled to obtain finer grained profiling information. Please check with Dbvisit support before enabling this.

set _SUBPROFILER=YES

 

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

 

  • No labels