14.3. System Trace Files

An Oracle instance's system trace files are stored in the same directory as the alert log file, in the directory specified by the system parameter BACKGROUND_ DUMP_DEST. The system trace files contain debugging, status, and error messages for each of the background processes, such as SMON, PMON, DBWx, LGWR, and so forth.

system trace file

A text file that pertains to a single background process and contains status, debugging, or error information about that background process. System trace files are stored in the directory specified by the system parameter BACKGROUND_ DUMP_DEST.

Janice, the DBA, notices that there are quite a few system trace files in the BACKGROUND_DUMP_DEST directory:

[oracle@oltp bdump]$ ls -l total ...

Get Oracle Database Foundations now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.