Oracle Support note  Interpreting Raw SQL_TRACE output  (39817.1).  TKPROF

As of version 11.1, it ’ s much easier to query either the v$diag_info or v$process views, as shown in the following examples:

SQL> SELECT value

2 FROM v$diag_info

3 WHERE name = 'Default Trace File';

VALUE

--------------------------------------------------------------------

/u00/app/oracle/diag/rdbms/dba111/DBA111/trace/DBA111_ora_23731.trc

SQL> SELECT p.tracefile

2 FROM v$process p, v$session s

3 WHERE p.addr = s.paddr

4 AND s.sid = sys_context('userenv','sid');

TRACEFILE

--------------------------------------------------------------------

/u00/app/oracle/diag/rdbms/dba111/DBA111/trace/DBA111_ora_23731.trc

Note that the v$diag_info view provides information for the current session only.