What Is The Use Of Alert Log File?

1.	What Is The Use Of Alert Log File?
Answer» The ALERT log is a log file that records database wide EVENTS. The INFORMATION in the ALERT log file is GENERALLY used for trouble shooting. FOLLOWING events are recorded in the ALERT log file: Database shutdown and startup information All non default parameters Oracle internal (ORA – 600) ERRORS Information about a modified control file At log switch The location of ALERT log file is specified in the BACKGROUND_DUMP_DEST parameter. The ALERT log is a log file that records database wide events. The information in the ALERT log file is generally used for trouble shooting. Following events are recorded in the ALERT log file:

Answer»

The ALERT log is a log file that records database wide EVENTS. The INFORMATION in the ALERT log file is GENERALLY used for trouble shooting.

FOLLOWING events are recorded in the ALERT log file:

Database shutdown and startup information
All non default parameters
Oracle internal (ORA – 600) ERRORS
Information about a modified control file
At log switch
The location of ALERT log file is specified in the BACKGROUND_DUMP_DEST parameter.

The ALERT log is a log file that records database wide events. The information in the ALERT log file is generally used for trouble shooting.

Following events are recorded in the ALERT log file:

Discussion