...
- 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. to Dbvisit Support
Turn off the profiling with command:
No Format SET PROFILER OFF
- Restart the process (mine or apply).
...