Oracle Database - Trace File (.trc)

Card Puncher Data Processing

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.

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

How to

Format it

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).

tkprof

Oracle - Tkprof

Configuration

MAX_DUMP_FILE

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

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle - SQL_TRACE

Set a trace identifier: The trace file identifier is added to the name of the trace files. Set Trace on: Perform SQL Actions Set off Where are the trace files? To find the trace file on...
Mos Lifetime Support
Oracle Company - My Oracle Support (MOS)

MOS is an acronym for My Oracle Support. It's the single entry for the Oracle Support. You can touch it on this URL: Contact: Local...
Card Puncher Data Processing
Oracle Database - Physical Database Structures (Files)

Oracle Database files include: data files, temporary files, control files, the server parameter file, the password file. redo log files, Archived Redo Log Files Parameter Files Alert...
Card Puncher Data Processing
Oracle Database - Trace Tool

You can enable the Trace feature either: within Oracle Enterprise Manager Database Control or by entering SQL commands with the DBMS_MONITOR package. Tools for tracing your work: dbms_monitor...



Share this page:
Follow us:
Task Runner