How get the trace for a program which executing through DBMS_SCHEDULER?
Hi,
We have a program which we are running through DBMS_SCHEDULER. We would like to enable the trace for this program what is the procedure for the same. Please note that , while running this program spawns new process as well. i did the following method,
1) Found the SID of the program through v$session.
2) enable the trace for that SID through execute dbms_system.set_sql_trace_in_session(106, 600, true);
But above method works for parent SID only, but as i said during the program running it spawns new processes also. Now i would like t get the trace for entire program not only for master processed.
Regards
APP-DBA.