a. The XXX MV Refresh Job is failing. Why is it failing ?
b. A User calls me and tells me that Oracle is reporting that a particular datafile 'N' is offline. When did the file go offline, for what reason ?
c. A particular datablock is corrupt. Since when has it been corrupt ?
d. Are any ORA-1555 errors occuring ?
e. When did Tablespace USERS hit 100% and stop auto-extending ?
can be answered simply by the DBA looking at the alert.log and/or trace files on occassion if not religiously and frequently. Oracle did introduce configurable Alerts in OEM and the views DBA_OUTSTANDING_ALERTS and DBA_ALERT_HISTORY but I am not sure if these are being configured and used.