To display 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. A good DBA will check this log regularly.