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
Alert Log File
The location of Alert log file 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 Alter Log file 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. You might have noticed
that in Unix environment we use “forward slash” (/) whereas in Windows
we user “backward slash” (\).
Oracle writes all the error messages and other alerts to this file
whenever that message occurs during it normal operations.
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