Trace log

The trace log is used for incident, error and event reporting. Most of the errors that happen in the database are captured on the trace files. Oracle Database administrators also can turn on trace for specific sessions. The trace file is not well formatted, but you will be able to search the errors (all ORA-xxx errors).

The table below provides the default location for the log file and the query you can run in case location has changed.

Log format Oracle version Tags Default file location
Plain text 10g/11g/12c (Linux and Windows)

oracle.trace

  • For 10g:

$ORACLE_HOME/admin/$ORACLE_SID/ udump/*.trc

  • For 11g/12c:

$ORACLE_HOME/diag/rdbms/$ORACLE_SID/ $ORACLE_SID/trace 

  • Query this location by issuing:

show parameter USER_DUMP_DEST;

Have we answered your question?

If not, please contact our technical support team via email by clicking the button below.

CONTACT US