Trace Files

Contents: Trace Files

Find Trace Files Locations

Finding locations of trace files.

SQL > select value from v$diag_info where name='Default Trace File';

To find All trace files for the current instance

SQL> SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';

The path to the ADR trace directory for the current instance is returned.

To Determine the trace file for each Oracle Database process:

SQL>SELECT PID, PROGRAM, TRACEFILE FROM V$PROCESS;