{"id":47,"date":"2010-04-24T17:54:27","date_gmt":"2010-04-24T22:54:27","guid":{"rendered":"http:\/\/www.mcneelytech.com\/blog1\/?p=47"},"modified":"2024-06-18T13:00:26","modified_gmt":"2024-06-18T18:00:26","slug":"common-oracle-mistakes-small-businesses-make-mistake-7","status":"publish","type":"post","link":"http:\/\/www.mcneelytech.com\/blog1\/?p=47","title":{"rendered":"Common Oracle mistakes small businesses make \u2013 mistake #7"},"content":{"rendered":"<p><strong>Mistake #7: Not paying attention to the alert log<\/strong><\/p>\n<p>Oracle databases each have an alert log, which is a file to which the database writes about key events.&nbsp; Most entries in the alert log are just informational, such as summary information about database startups and shutdowns, online redo log switches, etc.<\/p>\n<p>Some entries, however, can show you that you&#8217;ve got some trouble brewing.&nbsp; Operations could be failing due to lack of space.&nbsp; The database might be reporting corrupt data blocks.&nbsp; Processes could be silently failing due to Oracle software bugs.&nbsp; Ignoring such entries could lead to poor application performance, application process failures, or database instability.<\/p>\n<p>Take a look at your alert log on a regular basis, searching for signs of trouble.&nbsp; You can do this in an automated fashion using Oracle Enterprise Manager or custom scripts, or you can simply manually view the log.<\/p>\n<p>Are you listening to what your database is telling you?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mistake #7: Not paying attention to the alert log<\/p>\n<p>Oracle databases each have an alert log, which is a file to which the database writes about key events.&nbsp; Most entries in the alert log are just informational, such as summary information about database startups and shutdowns, online redo log switches, etc.<\/p>\n<p>Some entries, however, can [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"_links":{"self":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/47"}],"collection":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=47"}],"version-history":[{"count":3,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":274,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions\/274"}],"wp:attachment":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}