Re: 10046 trace in dbms_job
- From: Arul Ramachandran <contactarul@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 7 Aug 2005 11:21:32 -0700
Duh!! I should have checked the bdump destination. Thanks to Christian and
Stephen for pointing me in the right direction.
Arul
On 8/6/05, stephen booth <stephenbooth.uk@xxxxxxxxx> wrote:
>
> 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.
>
--
Arul
Other related posts:
