Page Comparison

...

Profiling can be turned on for either MINE, APPLY or both. 

To turn on profiling:

...

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
   memory_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 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

APPLY (without having to stop the Apply process)

1. Start the command console and type

   No Format
   engine mine send memory_set PROFILER /home/oracle/..../prof_%S.%E engine mine 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 mine send memory_set PROFILER OFF engine mine 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
   memory_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. 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

...