Mistake #7: Not paying attention to the alert log
Oracle databases each have an alert log, which is a file to which the database writes about key events. Most entries in the alert log are just informational, such as summary information about database startups and shutdowns, online redo log switches, etc.
Some entries, however, can show you that you’ve got some trouble brewing. Operations could be failing due to lack of space. The database might be reporting corrupt data blocks. Processes could be silently failing due to Oracle software bugs. Ignoring such entries could lead to poor application performance, application process failures, or database instability.
Take a look at your alert log on a regular basis, searching for signs of trouble. You can do this in an automated fashion using Oracle Enterprise Manager or custom scripts, or you can simply manually view the log.
Are you listening to what your database is telling you?
No one looks at logs, just like they don’t look at errors nor RTFM. You know know better than that!
BTW, I can’t find the online store for your apparel with the logo, where is that please?
Charles, you troublemaker! 🙂
Is your McNeely Technology Solutions shirt getting worn-for-the-wear?