Blogroll dba

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);


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

Read valuable information about oradebug on this site, amoung others

By Laurent Schneider

Oracle Certified Master

3 replies on “oradebug tracefile_name”

Thanks Sven,
In 11g I also found :
SQL> select tracefile from v$process where pid=32;

Leave a Reply

Your email address will not be published.