Search notes:

SQLPATH - tracefile.sql

tracefile.sql selects the path to the trace file of the current session.
--
--     Display path to the trace file for the current session
--
select value trace_file
  from v$diag_info
 where name = 'Default Trace File';
Github repository Oracle-SQLPATH, path: /tracefile.sql
It is possible to insert a recognizable text into the filename of the tracefile:
alter session set tracefile_name = my_session;

See also

The name of a tracefile can also be found with oradebug tracefile_name.
find-trace-file.sql
v$diag_info
Oracle: files for ORACLE_PATH / SQLPATH

Index