System Trace Files - Oracle DBA

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:

She sees quite a few files for the DBW0 (database writer) background process, so she is concerned that there might be a problem with DBW0. She opens one of the DBW0 trace files, ord_dbw0_6181.trc, to see what the problem might be.

SYSTEM TRACE FILES

She looks at the contents of the file and realizes that most processes, including DBW0, generate a trace file at database startup. As a result, the trace file is merely informational in this case, and there appears to be nothing wrong with DBW0.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle DBA Topics