Tuesday, 6 November 2012

Oracle Debugging/Tracing a Concurrent Program

Oracle provides a neat way to Log/Trace and debug Concurrent programs. Enable the profile option 'Concurrent: Allow Debugging' preferably at the user level so that you don't end up with many many debug files.


Once the profile is enabled we have the Debug Options button on concurrent program submission window enabled. I am sure many of us never bothered noticing the button before.



While submitting the program click on Debug Options we new page opens with the various options. Enable tracing or FND Log(given the programs uses logging) and a log file is created something like *username_*request_id*.* in your DB udump directory.

No comments:

Post a Comment

Integrations Lead - Lessons learnt

 Integrations have been my passion for a while but like anything tech there is no credit given when things go right but always heaps of pres...