RE: 10046 trace in dbms_job

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <contactarul@xxxxxxxxx>
  • Date: Sat, 6 Aug 2005 21:37:52 +0200

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: