Versions Compared

Key

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

...

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

To turn on profiling:

Mine

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

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

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

    No Format
    SET PROFILER /home/oracle/..../prof_%S.%E
    set _THREADED_OCI NO
  4. Restart the Apply process (mine or apply).
  5. Wait for a few log switches.
  6. Zip and upload the resulting file to Dbvisit Support
  7. Turn off the profiling with command: 

    No Format
    SET PROFILER OFF
    set _THREADED_OCI YES
  8. Restart the

    process (mine or apply).

    Apply process

Note

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

Check this with "show _THREADED_OCI" prior to step 1

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

...