{"id":143,"date":"2013-10-24T11:29:00","date_gmt":"2013-10-24T16:29:00","guid":{"rendered":"http:\/\/www.mcneelytech.com\/blog1\/?p=143"},"modified":"2023-12-07T20:50:00","modified_gmt":"2023-12-08T02:50:00","slug":"fried-foods-heck-yeah-but-what-about-fried-databases","status":"publish","type":"post","link":"http:\/\/www.mcneelytech.com\/blog1\/?p=143","title":{"rendered":"Fried foods, heck yeah! But what about fried databases?"},"content":{"rendered":"<p>Ah, the State Fair of Texas has come and gone!\u00a0 We&#8217;re famous in the south for our fried foods, and the tradition is alive and well at the Fair.<\/p>\n<p>A few fried foods I&#8217;ve either seen or read about at the Fair over the years:<\/p>\n<p>Fried margarita<br \/>\nFried spinach dip<br \/>\nFried butter<br \/>\nFried Nutella<br \/>\nFried shrimp and grits<br \/>\nFried bubble gum<\/p>\n<p>In the spirit of this tradition, let&#8217;s pause to consider what sort of frying we could engage in as database administrators:<\/p>\n<p>Fry the network \u2013 About that fancy Infiband switch that is just taking up space behind your RAC cluster &#8230; that switch you got at the electronics store bargain table is just as good, right?\u00a0 Give it a try!<\/p>\n<p>Fry the SAN \u2013 Drop a few indexes, preferably on large tables.\u00a0 Who needs &#8217;em anyway?<\/p>\n<p>Fry the SGA \u2013 Stop using and\/or forcing bind variables, preferably on a large, complex, highly repetitive set of OLTP SQL with a wide range of variable values.\u00a0 Who needs binding?<\/p>\n<p>Get fried by a security audit \u2013 Be sure to set the SYSTEM password to manager and SYS to change_on_install.\u00a0 No one will ever guess your little scheme!<\/p>\n<p>Fry some political capital \u2013 Decide on your own what the database recovery point and recovery time objectives are for your organization.\u00a0 Who needs input from the business unit?<\/p>\n<p>Fry your yearly bonus \u2013 Repeatedly put off recovery testing.\u00a0 What possibly could go wrong?<\/p>\n<p>Fry your boss&#8217;s nerves\u2013- Any of the above should suffice.<\/p>\n<p>Fry your nerves \u2013 Keep putting off that vacation.\u00a0 How will it ever fit into that hectic project schedule anyway?<\/p>\n<p>Fry your vacation \u2013 Once you finally manage to take a vacation, keep checking your email.\u00a0 Check at least twice an hour, more often if you&#8217;re at a swanky restaurant with your spouse.\u00a0 Spouses really dig that.<\/p>\n<p>Fry your sanity \u2013 Wait, you&#8217;re a DBA.\u00a0 That was gone long ago!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ah, the State Fair of Texas has come and gone! We&#8217;re famous in the south for our fried foods, and the tradition is alive and well at the Fair.<\/p>\n<p>A few fried foods I&#8217;ve either seen or read about at the Fair over the years:<\/p>\n<p>Fried margarita Fried spinach dip Fried butter Fried Nutella Fried [&#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-143","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\/143","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=143"}],"version-history":[{"count":3,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/143\/revisions"}],"predecessor-version":[{"id":146,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/143\/revisions\/146"}],"wp:attachment":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=143"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}