trace to request set r12

[satish]

Dear Erman,

How can we enable trace to a request set.Do we need to enable trace for all the programs inside the request set? like going to concurrent->program->define and enabling check box for all the programs in request set?

Thank you

[ErmanArslansOracleBlog]

Normally yes..
However, if you submit this concurrent request set by a specific user, you can also do the following;

Enable user level tracing for the user that will submitting the request set.  
This will generate a SQL trace file for all SQL executed. (including all the sql from user login to the execution of the entire request set.)

You can check the following document for enabling user trace:

How To Create a User Event Trace by Using Profile Option: Initialization SQL Statement - Custom
(Doc ID 170223.1)