Laurent Schneider

oradebug tracefile_name

I have enabled tracing in a session and now I want to retrieve the name of the tracefile.

Ex: my session has sid 335.

How do I retrieve trace file name from sqlplus ?


select pid from v$process where addr in 
(select paddr from v$session where sid=335);

       PID
----------
        47

Now I can use oradebug to reveal tracefile name


SQL> oradebug setorapid 47
Unix process pid: 1372408, image: oracle@dbsrv01 (TNS V1-V3)
SQL> oradebug tracefile_name
/u01/app/oracle/admin/LSC01/udump/lsc01_ora_1372408.trc

Read valuable information about oradebug on this site, amoung others

This entry was posted on Thursday, April 10th, 2008 at 16:27 and is filed under oracle, dba. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Post to : del.icio.us - Digg it - Furl - reddit - Spurl

Put your code in <code> and </code> tags

3 Responses to “oradebug tracefile_name”

Laurent Schneider Says:
April 10th, 2008 at 16:36

I just found another valuable information to find out file name without oradebug :

http://blog.psftdba.com/2006/12/retrieving-oracle-trace-files-via.html

SELECT LOWER(d.name)||'_ora_'||p.spid
||DECODE(p.value,'','','_'||value) tracefile_name
FROM v$parameter p, v$database d, sys.v_$session s, sys.v_$process p
,(SELECT sid FROM v$mystat WHERE rownum=1) m
WHERE p.name = 'tracefile_identifier'
AND s.paddr = p.addr
AND s.sid = m.sid
/

Sven Vetter Says:
April 10th, 2008 at 18:16
Hi Laurent

They is an easier way.
Update to Oracle 11g and use:

select value from v$diag_info where name=’Default Trace File’;

Greetings
Sven

Laurent Schneider Says:
June 17th, 2008 at 12:57

Thanks Sven,
In 11g I also found :

SQL> select tracefile from v$process where pid=32;
TRACEFILE
--------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/tinf11/TINF11/trace/TINF11_ora_868504.trc

Use <code> and </code> to post code

oradebug tracefile_name

3 Responses to “oradebug tracefile_name”

Leave a Reply