Re: Tracefiles not generated

Sorry - my mistake.
It is Oracle 9.2.0.6 on HP UX
I am running the trace connected as SYSTEM from a windows sql*plus When I use tracefile_identifier the DO get the name I would expect f.ex.
dvega2_ora_4888_MWHI.trc but without the identifier they are simply not there.

I don't see a difference in init.ora parameters between this instance and other instances where I do not have this problem. Only difference is that the other instances are on Solaris but the naming is the same:
<sid>_ora_<spid>.trc

fitzjarrell_at_cox.net skrev:

> 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.
> >
> > Kind regards
> > Kurt Laugesen
>
> No Oracle version, no O/S, so how do you expect assistance?
>
>
> David Fitzjarrell
Received on Wed Sep 20 2006 - 09:50:31 CDT