Display Trace File's Name and Location

Display Trace File's Name and Location

SQL> oradebug setmypid

Statement processed.

SQL> alter database backup controlfile to trace;

Database altered.

SQL> oradebug tracefile_name

/U01/oracle/dump01/oracle/joshi/udump/joshi_ora_8856.trc

Find out trce file name without oradebug :

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

/

@Oracle 11g --

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

select tracefile from v$process where pid=2;