Tracing/Debugging Oracle Applications Concurrent Programmes - 11i/R12
Diagnosing/Tracing Oracle Applications Concurrent Programmes 11i/R12 Simple tracing :- Creates a trace file without bind or wait (tracing without using event 10046 at level 12) Query the Concurrent programmes definition Check the Enable Trace check box Run the concurrent program using relevant responsibility Note down the concurrent request number after submitting Go to the oracle udump directory and find the trace file. Trace file names normally contain the os process id. Extended Tracing:- Creates a trace file with bind and wait (tracing with binds and waits using event 10046 at level 12) Set Profile Value at respective level Go to the SRS screen of the respective responsibility to submit the request you want to trace Select the name of the request Click on the debug options button (If you don’t set the profile option the debug option won’t be enabled) Clicking debug options take you to create debug rule page