To continue reading for free, register below or login
To read more you must become a member of SearchOracle.com
Oracle logs important messages about the database to a log called the alert log. This log is there to alert you to major events in the database. You can see when the database was started and stopped. You can see when a log switch occurs. You can see many other things. So the DBA should check the contents of the alert log on a regular basis. I check my alert logs at least once every two hours during the working day.
The alert log is stored in the directory pointed to by the BACKGROUND_DUMP_DEST initialization parameter. To see this parameter's value, sign on to SQL*Plus as SYSTEM and issue the following:
SHOW PARAMETER background_dump_dest
|
