Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to distinguish b/w normal trace file and different Sessions enabled SQL trace files?
Suppose more than two users generate their tracefiles through SQL Trace
utility on The Operating system (windows) at the same time, than How
would we tag their trace files through a method as you said. How would
we find their trace files among others?
Thanks in Advance
Ghalib wrote:
> 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 - 10:51:14 CDT