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: How to distinguish b/w normal trace file and different Sessions enabled SQL trace files?

Re: How to distinguish b/w normal trace file and different Sessions enabled SQL trace files?

From: Ghalib <ghalib314_at_yahoo.com>
Date: 26 Jul 2006 00:49:39 -0700
Message-ID: <1153900179.086170.279170@m79g2000cwm.googlegroups.com>

Suppose several persons enable their sessions at at time, so this will set a particular name for each trace file which will be generated on Windows Professional Server.

Asad

sybrandb wrote:
> Ghalib wrote:
> > Is there any way to differentiate between normal trace files and
> > different Session's SQL enabled trace files which generate in udump
> > folder on Operating System?
> > I want to have a script which distinguishes between different
> > Session's SQL enable trace files and normal trace files.
> > So we can know that these files are generated due to enabling sql trace
> > utility.
> >
> > Thanks in Advance.
> >
> > ASAD
>
> Just set the tracefile_identifier to something.
> alter session set tracefile_identifier='....'
> The tracefile_identifier will end up in the trace file name
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Wed Jul 26 2006 - 02:49:39 CDT

Original text of this message

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