Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

To turn on profiling:

...

MINE

  1. Shutdown the Mine MINE process
  2. Edit the *-MINE.ddc DDC file.
  3. Add the following line to the DDC file (give full path name):  

    No Format
    memory_set PROFILER /home/oracle/..../prof_%S.%E
  4. Restart the Mine 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:

    No Format
    # memory_set PROFILER /home/oracle/..../prof_%S.%E
  8. Stop and restart the Mine MINE process

...

APPLY

  1. Shutdown the Apply APPLY process
  2. Edit the *-APPLY.ddc DDC file.
  3. Add the following line to the DDC file (give full path name):  

    No Format
    memory_set PROFILER /home/oracle/..../prof_%S.%E
    memory_set _THREADED_OCI NO
  4. Restart the Apply 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:

    No Format
    # memory_set PROFILER /home/oracle/..../prof_%S.%E
    # memory_set _THREADED_OCI NO
  8. Stop and restart the Apply APPLY process

 

Note

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

memory_set _SUBPROFILER=YES

...