...
- Edit the relevant DDC file, *-MINE.ddc for the mine process and *-APPLY.ddc for the apply process.
Add the following line to the DDC file (give full path name):
No Format SET PROFILER /home/oracle/..../prof_%S.%E
- Restart the process (mine or apply).
- Wait for a few log switches.
- Zip and upload the resulting file to support.
Turn off the profiling with command:
SET PROFILERNo Format SET PROFILER OFF
- Restart the process (mine or apply).
...