Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tracefiles not generated

Re: Tracefiles not generated

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 20 Sep 2006 07:33:32 -0700
Message-ID: <1158762812.312347.313920@h48g2000cwc.googlegroups.com>

nospam_kurt.laugesen_at_gmail.com wrote:
> I am trying to trace my sql (setting event 10046 either in my own
> session or using dbms_system.set_ev).
> I have done this many times before, but I am now working on some new
> instances, that I have not created, and the funny thing is that nothing
> happens. No tracefiles are generated and no errors reported.
> Only when i set tracefile_identfier=<something> do the files get
> generated.
> This means I CAN in fact do my job, but it still puzzles me, I have
> never seen this behaviour before.
>
> It also makes it hard to trace another session, since I have to assure
> that they set tracefile_identier in their session before I start
> tracing a part of a long batchrun.
>

I would talk to the relevant DBA contact for the instances you are having problems with and work with them. Received on Wed Sep 20 2006 - 09:33:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US