Database Message Log (Oracle)
You can use this procedure to display the database message log.
Alternatively, use transaction code ST04.
This function lists information from the ALERT file (an error and message file provided by Oracle). This file includes important information about error situations and the general status of the database. Make sure that you check this log regularly.