{"id":53,"date":"2010-05-02T11:55:16","date_gmt":"2010-05-02T16:55:16","guid":{"rendered":"http:\/\/www.mcneelytech.com\/blog1\/?p=53"},"modified":"2024-06-18T12:59:46","modified_gmt":"2024-06-18T17:59:46","slug":"common-oracle-mistakes-small-businesses-make-mistake-9","status":"publish","type":"post","link":"http:\/\/www.mcneelytech.com\/blog1\/?p=53","title":{"rendered":"Common Oracle mistakes small businesses make \u2013 mistake #9"},"content":{"rendered":"<p><strong>Mistake #9: Not keeping an eye on database space allocation<\/strong><\/p>\n<p>What happens when you run out of space?<\/p>\n<p>If you run out of space between you car and the car in front of you, the two cars will crash into each other.&nbsp; If you come home with a bag of groceries and find that you have run out of space in your pantry, you&#8217;ll have to dig out those old cans of soup from three years ago, consolidate those seven partially full boxes of Ziploc bags, and decide if you&#8217;ll ever actually use that box of seaweed soup mix.&nbsp; Running out of space is no fun.&nbsp; If you proactively manage the various space allotments in your life, you will have fewer unhappy surprises.<\/p>\n<p>The same is true with your database.&nbsp; When key areas of your database or their associated external storage allocations fill, you can suffer from failed transactions, database outages or hangs, and lost logging information.&nbsp; Many space problems accumulate gradually and could have been prevented by early intervention.<\/p>\n<p>Are you watching your database for tablespace full conditions, nonextendable segments, and nonextendable datafiles?&nbsp; Are you properly managing your alert log, trace files, and archived redo logs?&nbsp; Are you watching your file systems\/drives for near-full conditions?&nbsp; Have you configured your datafiles not to try extend to a size larger than your file system\/drives can accommodate?<\/p>\n<p>Do you know how to do these things?&nbsp; <a href=\"http:\/\/www.mcneelytech.com\/company.html\" target=\"_blank\" rel=\"noopener\">Contact us<\/a> if we can help.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mistake #9: Not keeping an eye on database space allocation<\/p>\n<p>What happens when you run out of space?<\/p>\n<p>If you run out of space between you car and the car in front of you, the two cars will crash into each other.&nbsp; If you come home with a bag of groceries and find that you [&#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":[],"class_list":["post-53","post","type-post","status-publish","format-standard","hentry","category-oracle","odd"],"_links":{"self":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/53","targetHints":{"allow":["GET"]}}],"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=53"}],"version-history":[{"count":4,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions"}],"predecessor-version":[{"id":272,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions\/272"}],"wp:attachment":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=53"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=53"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}