tracefile.sql
-- -- Display path to the trace file for the current session -- select value trace_file from v$diag_info where name = 'Default Trace File';
alter session set tracefile_name = my_session;
oradebug tracefile_name
find-trace-file.sql
v$diag_info
Index