Page Comparison

...

1. Turning on profiling without having to stop and start Mine MINE or ApplyAPPLY, OR
2. Editing the DDC file and then stopping and starting the MineMINE/Apply 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 plog 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

APPLY (without having to stop the

...

APPLY process)

1. Start the command console and type

   No Format
   engine mineapply send memory_set PROFILER /home/oracle/..../prof_%S.%E engine mineapply send memory_set _THREADED_OCI YES

2. Wait for a few plog 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 mineapply send memory_set PROFILER OFF engine mineapply 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 plog 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

...

memory_set _SUBPROFILER=YES

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

...