Versions Compared

Key

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

...

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

    No Format
    SETmemory_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:

    No Format
    SET# memory_set PROFILER OFF/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):  

    No Format
    SETmemory_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:

    No Format
    SET# memory_set PROFILER OFF
    /home/oracle/..../prof_%S.%E
    # memory_set _THREADED_OCI YESNO
  8. Restart the Apply process

...

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

...

 

Note

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

...