From oracle-l-bounce@freelists.org Sun Aug 7 13:23:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j77INU6U020953 for ; Sun, 7 Aug 2005 13:23:30 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j77INPIP020944 for ; Sun, 7 Aug 2005 13:23:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 05D731DC588; Sun, 7 Aug 2005 13:23:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28291-02; Sun, 7 Aug 2005 13:23:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7AD621DC340; Sun, 7 Aug 2005 13:23:23 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Jya2sm3KiSJ+u3NcUlCsyJBUaGe7yd2olmEcOXVuvqF7ZNw7V82GOe4fAv1K2zMMWJfBbW4lSManhbDfIl/L4AGUNj7/GN8aHgkMB9rmDZ9C+R8o0PL418j9Jpz0FQxe6JJMb/EdDgefG+ZQhEuZ1V/fzCEW/nvLcUPM6rFWAks= Message-ID: <1c1a6299050807112139b58791@mail.gmail.com> Date: Sun, 7 Aug 2005 11:21:32 -0700 From: Arul Ramachandran To: oracle-l@freelists.org Subject: Re: 10046 trace in dbms_job In-Reply-To: <687bf9c4050806123975425b66@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1086_31785533.1123438892441" References: <1c1a62990508061213271d22f2@mail.gmail.com> <687bf9c4050806123975425b66@mail.gmail.com> X-archive-position: 23518 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: contactarul@gmail.com Precedence: normal Reply-To: contactarul@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.7 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_1086_31785533.1123438892441 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Duh!! I should have checked the bdump destination. Thanks to Christian and= =20 Stephen for pointing me in the right direction. Arul On 8/6/05, stephen booth wrote: >=20 > On 06/08/05, Arul Ramachandran 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. Bu= t > > the trace files are not generated in user_dump. > > >=20 > Have you looked in bdump (background dump)? >=20 > 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. >=20 > I think it's worth a look. >=20 > Stephen >=20 > -- > It's better to ask a silly question than to make a silly assumption. >=20 --=20 Arul ------=_Part_1086_31785533.1123438892441 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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@gmail.com> wrote:
On 06/08/05, Arul Ramachandran <contactarul@gmail.com> wrote:
>  Whereas, when I ca= ll the procedure from dbms_job.submit ( with a commit
> after &n= bsp;), the procedure does what it is supposed to do with the DMLs. But
> the trace files are not generated in user_dump.
>

Hav= e you looked in bdump (background dump)?

It's not something I've eve= r 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 ------=_Part_1086_31785533.1123438892441-- -- http://www.freelists.org/webpage/oracle-l