oradebug

admin

SUPTOOL: ORADEBUG (Doc ID 29786.1)


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:

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

Sample Output

SQL> conn sys/<password> 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