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, FETCHER or all of the processes.
There are 2 ways to turn in profiling:
However, it is typically better to stop the process, enable the profiling and then restart the process.
Start the command console and type
engine mine send memory_set PROFILER /home/oracle/..../prof_%S.%E |
Turn off the profiling:
engine mine send memory_set PROFILER OFF |
Add the following line to the DDC file (give full path name):
memory_set PROFILER /home/oracle/..../prof_%S.%E |
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 |
Profiler can be enabled while APPLY is running but it will not collect all required performance statistics to diagnose the issue. Therefore it is not recommend to enable profiler on APPLY while it is running. |
Start the command console and type
engine apply send memory_set PROFILER /home/oracle/..../prof_%S.%E |
Turn off the profiling:
engine apply send memory_set PROFILER OFF |
Add the following line to the DDC file (give full path name):
memory_set PROFILER /home/oracle/..../prof_%S.%E |
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 |
Stop and restart the APPLY process
Start the command console and type
engine fetcher send memory_set PROFILER /home/oracle/..../prof_%S.%E |
Turn off the profiling:
engine fetcher send memory_set PROFILER OFF |
Add the following line to the DDC file (give full path name):
memory_set PROFILER /home/oracle/..../prof_%S.%E |
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 |
In some cases, sub profiling can also be enabled to obtain finer grained profiling information. Please check with Dbvisit support before enabling this.
|
Please see Configuration Variable Reference for more information on setting PROFILER.