How to Use Oradebug to Get Trace File Name and Location

APPLIES TO:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.3 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 26-Apr-2012***

GOAL

How to get trace file name and location from SQL*Plus when trace event is enabled in a session using 'Alter session'?

SOLUTION

Use the command: Oradebug tracefile_name 

For example:

1. At SQL*Plus prompt, execute:
      'Alter session set events ... ' statement to enable tracing.
2. Issue:
      Oradebug setmypid
      Oradebug tracefile_name

Sample Output

SQL> conn sys/sys as sysdba
Connected.

SQL> alter session set events '10046 trace name context forever, level 12';

Session altered.

SQL> oradebug setmypid
Statement processed.

SQL> oradebug tracefile_name
/u01/app/oracle/diag/rdbms/v1120/v1120/trace/v1120_ora_26077.trc