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 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 the trace files for Oracle Database processes:

• Submit the following query:

  SELECT PID, PROGRAM, TRACEFILE FROM V$PROCESS;