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: sybrandb <sybrandb_at_gmail.com>
Date: 25 Jul 2006 03:24:19 -0700
Message-ID: <1153823059.621829.46220@b28g2000cwb.googlegroups.com>

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 Tue Jul 25 2006 - 05:24:19 CDT

Original text of this message

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