Versions Compared

Old Version 9

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version Current

changes.mady.by.user Mike Donovan (Deactivated)

Saved on

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

...

There are 2 ways to turn in profiling:

  1. Turning on profiling without having to stop and start MINE or APPLY, OR
  2. Editing the DDC file and then stopping and starting the MINE/APPLY processes

MINE (without having to stop the MINE process)

  1. Start the command console and type

    No Format
    engine mine send memory_set PROFILER /home/oracle/..../prof_%S.%E
  2. Wait for a few log switches.
  3. 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)

  4. Turn off the profiling:

    No Format
    engine mine send memory_set PROFILER OFF

MINE (shutting down MINE)

  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 MINE process
  5. Wait for a few log PLOG switches.
  6. Zip and upload the resulting file 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
    SET# memory_set PROFILER OFF
  8. Restart the Mine process

Apply

  1. Shutdown the Apply 
    /home/oracle/..../prof_%S.%E
  2. Stop and restart the MINE process

APPLY (without having to stop the APPLY process)

Note

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.

  1. Start the command console and type

    No Format
    engine apply send memory_set PROFILER /home/oracle/..../prof_%S.%E
  2. Wait for a few log switches
  3. 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)

  4. Turn off the profiling:

    No Format
    engine apply send memory_set PROFILER OFF

APPLY (shutting down 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
set _THREADED_OCI NO
  4. Restart the Apply 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
    SET# memory_set PROFILER OFF
set _THREADED_OCI YES

  8. Restart the Apply process

...

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

  1. /home/oracle/..../prof_%S.%E

  2. Stop and restart the 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.

No Format
memory_set _SUBPROFILER=YES

 

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

...