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?
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 DBAReceived on Tue Jul 25 2006 - 05:24:19 CDT
![]() |
![]() |