Locate the trace file

The trace file is generated on the database server. Its location and name are in the TRACEFILE column of the system view V$PROCESS. Use the following query to fetch this and other useful information:

select s.sid,s.serial#,s.audsid,s.username,s.osuser, s.client_identifier, s.sql_trace,s.action, p.spid, p.TRACEFILE
from v$session s,v$process p
where s.paddr=p.addr
and s.username is not null;

The username for nonbatch jobs is CDRRUN and the client_identifier is the DMW username of the user whose session is traced. If tracing is running for a particular user, the trace file identifier is appended to the trace file name just before the .trc extension.