Finding Trace Files

Trace files are stored in the Automatic Diagnostic Repository (ADR), in the trace directory under each ADR home. To help you locate individual trace files within this directory, you can use data dictionary views. For example, you can find the path to your current session's trace file or to the trace file for each Oracle Database process.

To find the trace file for your current session:

• Submit the following query:

  SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Default Trace File';
  

  The full path to the trace file is returned.

To find all trace files for the current instance:

• Submit the following query:

  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:

• Submit the following query:

  SELECT PID, PROGRAM, TRACEFILE FROM V$PROCESS;