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

--
http://www.freelists.org/webpage/oracle-l