Re: Help:Trace file name

I don't know which operating system you are on, so I'll assume Unix.

The file name is composed of the value of $ORACLE_SID, the type of Oracle process, and the ID of the Oracle process.

The Oracle process type, in your case, would be "ora" as that is the process generating the trace. However, it could be several others, including "smon" and "pmon."

As example, if your ORACLE_SID is "test," the name of a trace file might be test_ora_12345.trc.

                                  Ric

"DODO" <dodo_at_Ihatespam.com> writes:

> Hello,
> Does anyone know how Oracle names its trace files? I mean, after issuing the
> ALTER SESSION SET SQL_TRACE = TRUE command, a .trc file is created on the
> server. If you delete that file a new file with the same name is created, so
> it is consistent.
> TIA,
> DODO
>
>
 

-- 
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                rwessman_at_us.oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.