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

.

Relevant Pages

  • [ANNOUNCE][PATCH 0 of 4] zedtrace, a general-purpose binary tracer
    ... It's called zedtrace and is ... Trace events from different subsystems ... This results in a set of per-cpu trace files in the current directory: ... script as native param variables. ...
    (Linux-Kernel)
  • Re: CLOB updates using ADODB not showing in trace file
    ... take the money and provide extended support, then I feel perfectly within rights to post a question ... SQL_TRACE is set to TRUE at the database level. ... Initially trace was being enabled via a logon database trigger, but since we noticed the problem I ... we have searched all the trace files ...
    (comp.databases.oracle.misc)
  • Re: Setting up Trace in SQL
    ... > The company has a policy and states that we have to audit> our databases. ... >>SQL Server MVP ... But supposed if I were to re-start the DB, the>>> audit does not kick off at all coz the trace files still ...
    (microsoft.public.sqlserver.security)
  • Re: urgent problem that I want to have a comment about
    ... We get exactly the same problem when we build the MFC dll in debug mode. ... You have not said what kind of trace facility you are using, and therefore, there is no ... If these "really good trace files" allocate memory, ...
    (microsoft.public.vc.mfc)
  • Re: WSE Authentication problem when calling from a dll
    ... You are not being able to see the trace files on the web service side ... So I have the web page call a dll which calls the proxy. ... password that I want to use in the wse policy wizard on the web page ...
    (microsoft.public.dotnet.framework.webservices.enhancements)