Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 10: Oracle Performance Tuning
Background Process, Event & User Trace Files
Oracle trace files contain information pertaining to certain event that
happens in the regular operation of Oracle. The location of these trace
files is described by BACKGROUND_DUMP_DEST initialization parameter. For
Oracle systems that follow OFA (Oracle Flexible Architecture) or in
other words standard directory architecture of Oracle files, the
location of these trace files will be as follows.
In Windows Server 2003/NT/XP,
%ORACLE_BASE%\admin\SID\bdump whereas in Unix it would be $ORACLE_BASE/admin/SID/bdump.
Where SID is the name of the Oracle Instance.
All trace files have file extension of .trc no matter whether it is
Background process, Event or User trace file. In Windows environment,
the background processes will generate the following files.
Process Monitor (PMON): sidPMON.trc
System Monitor (SMON): sidSMON.trc
Database Writer (DBW0): sidDBW0.trc
Archive Process (ARC0): sidARC0.trc
Log Writer (LGWR): sidLGWR.trc
Chapter 10: Oracle Performance Tuning
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning