RE: 10046 trace in dbms_job

Hi Arul

 

>I am trying to trace a simple stored procedure that 
>does DMLs, with a 'execute immediate' that set
>events 10046 trace. When I execute the procedure 
>from sqlplus, I am able to see the trace in
>user_dump destination as expected.

 

Jobs are executed by background processes. Therefore the trace files should be 
located under bdump, not udump.

 

Regards,

Chris

Other related posts: