Alert Log

Contains Information

 * Materialized view errors
 * Internal errors
 * Shutdown/startup
 * alter system/alter database
 * non default parameter values
 * advisory info
 * background process info
 * shared server and dispatcher errors.

Location

 * V$DiagInfo
 * Alert Log Contents from EM
 * DIAGNOSTIC_DEST/DIAG/RDMS/DATABASENAME/INSTANCENAME/ALERT