Re: 10046 trace in dbms_job

  • From: stephen booth <stephenbooth.uk@xxxxxxxxx>
  • To: contactarul@xxxxxxxxx
  • Date: Sat, 6 Aug 2005 20:39:31 +0100

On 06/08/05, Arul Ramachandran <contactarul@xxxxxxxxx> wrote:
>  Whereas, when I call the procedure from dbms_job.submit ( with a commit
> after  ), the procedure does what it is supposed to do with the DMLs. But
> the trace files are not generated in user_dump.
>  

Have you looked in bdump (background dump)?

It's not something I've ever tried but from what I know of how jobs
work I'd expect the trace files to end up in bdump.

I think it's worth a look.

Stephen

-- 
It's better to ask a silly question than to make a silly assumption.
--
//www.freelists.org/webpage/oracle-l

Other related posts: