Dbvisit Replicate can collect profiling or performance statistics information which will assist Dbvisit support to diagnose performance issues.

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

There are 2 ways to turn in profiling:

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

MINE (without having to stop the MINE process)

Start the command console and type

engine mine send memory_set PROFILER /home/oracle/..../prof_%S.%E

Wait for a few log switches.
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)

Turn off the profiling:

engine mine send memory_set PROFILER OFF

MINE (shutting down MINE)

Shutdown the MINE process
Edit the *-MINE.ddc DDC file.
Add the following line to the DDC file (give full path name):
```
memory_set PROFILER /home/oracle/..../prof_%S.%E
```
Restart the MINE process
Wait for a few PLOG switches.
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)
Turn off the profiling with by removing the profiler command OR adding a comment in front of the line in the DDC file:
```
# memory_set PROFILER /home/oracle/..../prof_%S.%E
```
Stop and restart the MINE process

APPLY (without having to stop the APPLY process)

Start the command console and type

engine apply send memory_set PROFILER /home/oracle/..../prof_%S.%E
engine apply send memory_set _THREADED_OCI YES

Wait for a few PLOG switches.
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)

Turn off the profiling:

engine apply send memory_set PROFILER OFF
engine apply send memory_set _THREADED_OCI NO

APPLY (shutting down APPLY)

Shutdown the APPLY process
Edit the *-APPLY.ddc DDC file.

Add the following line to the DDC file (give full path name):

memory_set PROFILER /home/oracle/..../prof_%S.%E
memory_set _THREADED_OCI NO

Restart the APPLY process
Wait for a few PLOG switches.
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)
Turn off the profiling with by removing the profiler command OR adding a comment in front of the line in the DDC file:
```
# memory_set PROFILER /home/oracle/..../prof_%S.%E
# memory_set _THREADED_OCI NO
```
Stop and restart the APPLY process

In some cases, sub profiling can also be enabled to obtain finer grained profiling information. Please check with Dbvisit support before enabling this.

memory_set _SUBPROFILER=YES

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

Browser not supported