How to make a TKPROF file for a concurrent launched from a Concurrent Set?
not sure if this is the correct Community to post this problem, but we have a performance issue with a concurrent (Calculation of Oracle Incentive Compensation). The standard way to monitor any heavy query is by generating a tkprof file while executing a single request enabling Debug Options and marking SqlTrace for the request.
We have a request set where we realize a performance issue on a specific request within the concurrent set, so in order to re-produce the problem and trace any heavy query we executed the single concurrent request with debug options enabled. The problem was that launching the single concurrent the performance issue was not presented but launching with the request set the problem appears (and within the concurrent tried to be traced in single mode). So now we would like to obtain an TKPROF file for the concurrent, but launched within the concurrent set,…any clue how can I do that?