Re: Name of Oracle Trace

There is the document on Metalink about this problem. Doc ID: Note:1038578.6
Subject: SQL_TRACE FILES IN WRONG DIRECTORY, CONTAIN INFO FOR MANY SESSIONS Type: PROBLEM
Status: PUBLISHED

In MTS configuration trace information is spread between some trace files, because different
statements can be executed by different server processes. Unfortunately, I couldn't turn on
sql trace in MTS. Other words, when I've issued alter session set sql_trace=true,
no files was created in dump directories.

Serge Kosourikhin
Oracle DBA
JSC Bratsk Aluminium Plant
----- Original Message -----
From: <CHUCK_HAMILTON_at_qvc.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 17, 2000 1:58 AM
Subject: Re: Name of Oracle Trace

>
> Essentially the trace file name is ORAx.TRC where X is the process ID of
> the server process. (I'm not sure how it's done on MTS since server
> processes are shared. Maybe someone can enlighten us.) There's a slight
> twist on NT though. The v$process table reports the PID in hex and it
needs
> to be converted to decimal. You'll need to write a function to do this.
>
> On unix, use this query
>
> SELECT
> 'ora_'||to_number(p.spid,'09999')||'.trc' tracefile
> FROM
> v$process p ,
> v$session s
> WHERE
> s.audsid = userenv('sessionid')
> and s.paddr = p.addr;
> --
> Chuck Hamilton
> QVC Inc.
> Enterprise Technical Services
> Oracle DBA
>
>
>
> Place for
> oracle To: Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>
> <place4oracle@ cc: (bcc: CHUCK
HAMILTON/QVC)
> yahoo.com> Subject: Name of Oracle
Trace
> Ext: NA
> Sent by:
> root_at_fatcity.c
> om
>
>
> 05/16/00 06:04
> AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> Hello,
>
> Does someone know how to found the Oracle trace name.
> We have ORA00512.trc but how can I know that it is my
> trace.
>
> regards
> P.T and H.E
>
>
> =====
> Place4oracle
> http://altern.org/place4oracle/place4oracle.html
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Place for oracle
> INET: place4oracle_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Author:
> INET: CHUCK_HAMILTON_at_qvc.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed May 17 2000 - 01:43:19 CDT