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?

Asad








Ghalib wrote:
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

.

Relevant Pages

  • Re: problems w/ fn_trace_gettable
    ... Andrew J. Kelly SQL MVP ... I am able to open the trace files w/ Profiler ... >>On the SQL Server or on a network location? ...
    (microsoft.public.sqlserver.server)
  • Re: problems w/ fn_trace_gettable
    ... The trace files are located on the server running the SQL ... >Can you show us the exact command you are using? ...
    (microsoft.public.sqlserver.server)
  • Re: Reading .trc files of SQL Server 2000/2005
    ... SQLBenchmarkPro is a tool I designed to organise trace scheduling, ... collection & analysis accross multiple server concurrently - for both SQL ... SQL Profiler can read the trace files, ...
    (microsoft.public.sqlserver.tools)
  • Re: Need an Excellent SQL tutorial
    ... SQL in 10 minutes by Sams? ... "Linux - an operating system that wants to work. ... Windows - an operating system that mostly works. ... "Arthur Hoornweg" wrote in message ...
    (borland.public.delphi.non-technical)
  • Re: WCE user manual
    ... operating system where you could say something about SQL CE, the Web server, ... etc. and have it apply to all devices running Windows CE. ...
    (microsoft.public.windowsce.platbuilder)