Disabling tracing from concurrent program definition window causing performance issue
There is something wierd about a couple of custom concurrent programs we are using. These jobs has Oracle Report as executable. Earlier these jobs use to take around one and a half hours on an average to get completed even if it is not processing any data at all. In order to trouble shoot the performance issues we enabled the trace option from the cuncurrent program defination window by checking the Enable Trace check box. Surprisingly the job got completed in less that a minute.
When we disabled the trace option then again it started executing for hours. We have enabled and disabled the tracing several times and it looks like whenever trace is enabled the job is performing as expected, but disabling the trace is causing the performance to go down whereas the reverse case might have been logical.