...
Profiling can be turned on for either MINE, APPLY or both, FETCHER or all of the processes.
There are 2 ways to turn in profiling:
- Turning on profiling without having to stop and start MINE or , FETCHER, APPLY, OR
- Editing the DDC file and then stopping and starting the MINE/APPLY/FETCHER processes
MINE (without having to stop the MINE process)
...
- Shutdown the APPLY process
- Edit the *-APPLY.ddc DDC file.
Add the following line to the DDC file (give full path name):
No Format memory_set PROFILER /home/oracle/..../prof_%S.%E
- 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:
No Format # memory_set PROFILER /home/oracle/..../prof_%S.%E
Stop and restart the APPLY process
FETCHER (without having to stop the FETCHER process)
Start the command console and type
No Format engine fetcher 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 fetcher send memory_set PROFILER OFF
FETCHER (shutting down FETCHER)
- Shutdown the FETCHER process
- Edit the *-FETCHER.ddc DDC file.
Add the following line to the DDC file (give full path name):
No Format memory_set PROFILER /home/oracle/..../prof_%S.%E- Restart the FETCHER 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:
No Format # memory_set PROFILER /home/oracle/..../prof_%S.%E- Stop and restart the FETCHER process
| Note | ||
|---|---|---|
In some cases, sub profiling can also be enabled to obtain finer grained profiling information. Please check with Dbvisit support before enabling this.
|
...