Versions Compared

Version Old Version 10 New Version Current
Changes made by

Arjen Visser

Petr Horejs

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)

  1. Start the command console and type

    No Format
    engine apply send memory_set PROFILER /home/oracle/..../prof_%S.%E
engine apply send memory_set _THREADED_OCI YES
  2. Wait for a few PLOG 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
engine apply send memory_set _THREADED_OCI NO

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
memory_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 PROFILER OFF
# memory_set PROFILER /home/oracle/..../prof_%S.%E
# memory_set _THREADED_OCI YESNO

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

 

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.

...