{"id":1182,"date":"2007-01-18T12:00:00","date_gmt":"2007-01-18T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1182"},"modified":"2007-01-18T12:00:00","modified_gmt":"2007-01-18T12:00:00","slug":"werewolves-beware","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2007\/01\/18\/werewolves-beware\/","title":{"rendered":"Werewolves, beware!"},"content":{"rendered":"<p>A friend pointed out <a href=\"http:\/\/www.dba-oracle.com\/oracle_news\/2006_8_11_no_unnest_hint.htm\">a link to one of my blog postings<\/a> over at Burleson Consulting&#8217;s website that I wasn&#8217;t aware of.<\/p>\n<p>Whilst I appreciate Don Burleson&#8217;s fulsome praise of my communication skills, I think it&#8217;s only fair to make a few points of clarification.<\/p>\n<p>1) I was concerned that readers might misinterpret my intentions when I wrote that blog entry, to the extent of saying the following, which Don didn&#8217;t quote<\/p>\n<p><i>&#8220;When you see the solution, the words &#8216;Silver&#8217; and &#8216;Bullet&#8217; might pop into your mind. If so, let me point out that I worked it out by poring over execution plans, trying different approaches in full-sized test environments and, when you look at the problem, it&#8217;s actually a very localised problem with a large query&#8221;<\/i><\/p>\n<p>In fact, if you look at the whole series of three blogs and the follow-up comments, you&#8217;ll see that this exercise might have been a quick fix, but getting to the bottom of why it might have helped took some time. <\/p>\n<p><a href=\"http:\/\/18.133.199.212\/?p=820\">http:\/\/18.133.199.212\/?p=820 href=&quot;http:\/\/18.133.199.212\/?p=818&quot;&gt;http:\/\/18.133.199.212\/?p=818 href=&quot;http:\/\/18.133.199.212\/?p=813&quot;&gt;http:\/\/18.133.199.212\/?p=813 I don&apos;t know *why* it worked, how can I be sure that it&apos;s really fixed the problem and hasn&apos;t introduced new problems? Even if I decide to ignore such details, an inflexible fix like this might well cause problems when you upgrade to future versions of Oracle, because a new and more efficient execution plan is unavailable as a consequence. The fact is, I always worry about such an <i>apparently<\/i> easy solution because there are likely to be unexpected consequences. There are few free lunches in this business.<\/p>\n<p>2) The link is broken (although I&#8217;m sure it wasn&#8217;t when it was first pointed out to me a couple of weeks ago). The correct links are listed above.<\/p>\n<p>3) &lt;joke&gt;Oh, and I *do* wish people wouldn&#8217;t link to old, pre-Serendipity blogs. It means I have to go and tidy up the formatting ;-)&lt;\/joke&gt;<\/p>\n<p>Anyway, if you still believe in the power of Silver Bullets, <a href=\"http:\/\/jonathanlewis.wordpress.com\/2006\/12\/31\/a-metaphor\/\">this<\/a> might convince you otherwise, as well as giving you a few laughs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A friend pointed out a link to one of my blog postings over at Burleson Consulting&#8217;s website that I wasn&#8217;t aware of. Whilst I appreciate Don Burleson&#8217;s fulsome praise of my communication skills, I think it&#8217;s only fair to make a few points of clarification. 1) I was concerned that readers might misinterpret my intentions&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2007\/01\/18\/werewolves-beware\/\">Continue reading <span class=\"screen-reader-text\">Werewolves, beware!<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1182","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1303,"url":"http:\/\/orcldoug.com\/blog\/2007\/08\/02\/why-you-cant-just-say-stop-feeding-the-troll\/","url_meta":{"origin":1182,"position":0},"title":"Why you can&#8217;t just say &#8216;Stop feeding the troll&#8217; &#8230;","date":"August 2, 2007","format":false,"excerpt":"... and walk away.In the course of the past year, I've heard more than one person suggest that Jonathan Lewis should stop debunking Don Burleson's arguments. Their opinion is that it makes Jonathan look narrow-minded and spiteful and that he should simply ignore Don, stop giving him extra publicity and\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":950,"url":"http:\/\/orcldoug.com\/blog\/2005\/08\/20\/jonathan-debunks-another-don-article\/","url_meta":{"origin":1182,"position":1},"title":"Jonathan debunks another Don article","date":"August 20, 2005","format":false,"excerpt":"I see that Jonathan Lewis has examined one of Don Burleson\ufffds recent articles in more detail When I saw this article via a posting on Radoslav Rusinov\ufffds blog, I figured it wouldn\ufffdt be too long before it was questioned and Jonathan\ufffds the very man to do so. Of course, Jonathan\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1050,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/10\/historical-perspective-part-2\/","url_meta":{"origin":1182,"position":2},"title":"Historical Perspective (Part 2)","date":"August 10, 2006","format":false,"excerpt":"Let's look at items 2 and 3 from the list in my previous blog1) You know you have a performance problem and can re-create it by running a specific part of the application, be it a user interaction or batch job.2) You have an intermittent but recurring performance problem which\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":934,"url":"http:\/\/orcldoug.com\/blog\/2005\/10\/07\/another-apology\/","url_meta":{"origin":1182,"position":3},"title":"Another Apology","date":"October 7, 2005","format":false,"excerpt":"I've received several emails pointing out Don Burleson's apology for calling me British instead of Scottish that was on his website (but has been removed now). I asked Don to take it down for a few reasons :-I was born and remain British. I was born and remain Scottish.The two\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":868,"url":"http:\/\/orcldoug.com\/blog\/2006\/02\/05\/we-never-learn-do-we\/","url_meta":{"origin":1182,"position":4},"title":"We Never Learn, Do We?","date":"February 5, 2006","format":false,"excerpt":"I had an interesting day at work yesterday. We've run into major performance problems when upgrading a number of Production databases from 8i to 9i. How could that happen, when we've performed regression tests to ensure that the applications perform as well as or better than they did on 8i?Probably\u2026","rel":"","context":"With 5 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1049,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/09\/historical-perspective-part-1\/","url_meta":{"origin":1182,"position":5},"title":"Historical Perspective (Part 1)","date":"August 9, 2006","format":false,"excerpt":"As mentioned in a few blog comments in the past, it's not the greatest idea to advertise on the web that you're going on holiday (or vacation if you prefer), given the easy availability of home addresses online. You might as well leave the back door open for the burglars\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1182"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1182\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1182"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}