| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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). Received on Tue May 16 2000 - 10:54:30 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |