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.
Parent topic: Use tracing and logging