...
Profiling can be turned on for either Mine, Apply or both.
To turn on profiling:
Mine
- Shutdown the Mine process
- Edit the relevant DDC file, *-MINE.ddc for the Mine process and *-APPLY.ddc for the Apply process.ddc DDC file.
Add the following line to the DDC file (give full path name):
No Format SET PROFILER /home/oracle/..../prof_%S.%E
- Restart the Mine process
- Wait for a few log switches.
- Zip and upload the resulting file to Dbvisit Support
Turn off the profiling with command:
No Format SET PROFILER OFF
- Restart the Mine process
Apply
- Shutdown the Apply process
- Edit the *-APPLY.ddc DDC file.
Add the following line to the DDC file (give full path name):
No Format SET PROFILER /home/oracle/..../prof_%S.%E set _THREADED_OCI NO
- Restart the Apply process (mine or apply).
- Wait for a few log switches.
- Zip and upload the resulting file to Dbvisit Support
Turn off the profiling with command:
No Format SET PROFILER OFF set _THREADED_OCI YES
Restart the
process (mine or 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 |
Please see Configuration Variable Reference for more information on setting PROFILER.
...