1.

What Is The Use Of Alert Log File? Where Can You Find 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:

The location of ALERT log file is specified in the BACKGROUND_DUMP_DEST parameter.


Discussion

No Comment Found

Related InterviewSolutions