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

3 thoughts on “oradebug tracefile_name”

  1. 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

  2. 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
    

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>