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
    memory_set PROFILER /home/oracle/..../prof_%S.%E
  4. Restart the MINE process
  5. Wait for a few log plog switches.
  6. Zip and upload the resulting files to Dbvisit Support. The profiler files will be in the location specified by the full path given (/home/oracle/..../prof_%S.%E)
  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 process

...

  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
    memory_set PROFILER /home/oracle/..../prof_%S.%E
    memory_set _THREADED_OCI NO
  4. Restart the APPLY process
  5. Wait for a few log plog switches.
  6. Zip and upload the resulting file to Dbvisit Support. The profiler files will be in the location specified by the full path given (/home/oracle/..../prof_%S.%E)
  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 process

...