What is the alert log?
I'm using Oracle 10g. My friend told me to go to the alert log and review the error messages. What is an alert log in Oracle? What is the use and purpose of this file? How to review this file and where exactly is it located?
The alert log is stored in the directory pointed to by the BACKGROUND_DUMP_DEST initialization parameter. To see...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
this parameter's value, sign on to SQL*Plus as SYSTEM and issue the following:
SHOW PARAMETER background_dump_dest