...
APPLY (without having to stop the APPLY process)
| Note |
|---|
Profiler can be enabled while APPLY is running but it will not collect all required performance statistics to diagnose the issue. Therefore it is not recommend to enable profiler on APPLY while it is running. |
Start the command console and type
No Format engine apply 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:
No Format engine apply send memory_set PROFILER OFF
...
| Note | ||
|---|---|---|
In some cases, sub profiling can also be enabled to obtain finer grained profiling information. Please check with Dbvisit support before enabling this.
| ||
| Note |
Please see Configuration Variable Reference for more information on setting PROFILER.
...