Oracle Database - Trace File (.trc)

1 - About

Trace File are trace (or dump) file that Oracle Database creates to help you diagnose and resolve operating problems.

Each server and background process writes to a trace file. When a process detects an internal error, it writes information about the error to its trace file.

3 - Linux File Format

The file name format of a trace file is sid_processname_unixpid.trc, where:

  • sid is the instance system identifier
  • processname is a three or four-character abbreviated process name identifying the Oracle Database process that generated the file (for example: pmon, dbwr, ora, or reco)
  • unixpid is the operating system process ID number

The following is a sample trace file name:$ORACLE_BASE/diag/rdbms/mydb/mydb/trace/test_lgwr_1237.trc where ORACLE_BASE is the Oracle Base Directory

4 - How to

4.1 - Format it

4.1.1 - SQL Developer

To see a formatted display of a SQL Trace file, drag the *.trc file onto the area above the SQL Worksheet (or open it by clicking File, then Open).

4.1.2 - tkprof

Oracle - Tkprof

5 - Configuration


Set the MAX_DUMP_FILE initialization parameter to at least 5000, to ensure that the trace file is large enough to store error information.

6 - Documentation / Reference

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap