{"id":786,"date":"2006-05-10T12:00:00","date_gmt":"2006-05-10T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=786"},"modified":"2006-05-10T12:00:00","modified_gmt":"2006-05-10T12:00:00","slug":"oug-scotland-2","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/05\/10\/oug-scotland-2\/","title":{"rendered":"OUG Scotland"},"content":{"rendered":"<p>Well, to start with, it was a great venue. Perfect size, perfectly &#8216;Edinburgh&#8217; and a nice coffee\/bar area. I understand some people were freezing cold, but I think I got lucky. It was also nice to see quite a few familiar faces, including the entire Edinburgh University IT posse! (At least you can get a decent chat about football with them, too)<\/p>\n<p>First up was Geoff Locke from Cap Gemini with a &#8220;Fast track to using Oracle&#8217;s Wait Interface (OWI) for Tuning&#8221;. This was probably my least favourite presentation of the day because I didn&#8217;t feel he spent much time talking about the wait interface so that was a bit disappointing. He had clearly based his presentation on his work in the field, though, which is probably more practically useful than me waffling on about px tests, so it depends what you&#8217;re looking for.<\/p>\n<p>Next was Simon Kelsey from BSkyB (one of my colleagues) with his very first user group presentation on compression and some of the performance implications. He did a great job and I wouldn&#8217;t have noticed he was nervous if I hadn&#8217;t known already &#128521; He seemed to enjoy himself too. As a Geordie lass might once have said, &#8216;if he can do it, anyone can&#8217; &#128521;<\/p>\n<p>Jonathan Lewis gave a couple of CBO presentations during the day but I particularly enjoyed the so-called &#8216;introduction&#8217; in the morning. Where Jonathan says &#8216;Introduction&#8217;, the rest of us hold our breath and listen carefully! To pick out one point which drew a few gasps from the audience, he illustrated how dropping an index <em>which is not even being used by a query<\/em> can change the optimiser&#8217;s strategy for the selectivity calculation and cause it to choose a different plan. I&#8217;m sure Peter Robson described this presentation as a &#8216;tour de force&#8217;, but I wasn&#8217;t really listening to him. I must stop doing that or I&#8217;ll get caught out one of these days!<\/p>\n<p>After lunch Moans Longballs Nogood reduced the room to fits of laughter, as usual, and also had some pretty interesting things to say about Opterons, operating systems and old men. He&#8217;s an expert on at least one of them &#128521; I spoke to a few people who had never heard Mogens speak and they were bowled over and charmed as usual. If you ever get the chance to see him, grasp it and listen carefully. He&#8217;s so busy taking the mickey out of everything and everyone that you need to pay attention for the good bits and make allowances for his martini-dry sense of humour!<\/p>\n<p>Of course, he overran, leaving less time for some bearded bloke to talk about the optimiser some more but that was okay, because he just took his full time too. Not content with that, he filled the audience&#8217;s head with even more startling information. Good job they had something light to round off the day (and a nice convenient coffee break before it for people to slip out the door early!)<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledoug.com\/images\/vaults.jpg\"><img decoding=\"async\" alt=\"\" border=\"0\" src=\"https:\/\/i0.wp.com\/oracledoug.com\/images\/vaults.jpg?w=750\" style=\"DISPLAY: block; CURSOR: hand; TEXT-ALIGN: center\" data-recalc-dims=\"1\"\/><\/a><br \/>I picked this photo out of the several that Peter took for me because Mogens thinks I look like I&#8217;m about to break into my Rock and Roll act! (Don&#8217;t stand in front of the projector Doug!) That&#8217;s Thomas Presslie doing the introduction.<\/p>\n<p>I think this was my least favourite delivery of this presentation but it went okay I think. It was the end of a long day, everyone was a bit tired and I was keen not to over-run or people would kill me. Hopefully it got people thinking about the possibilities for their own testing and some might read the paper. I&#8217;d be happy with that result.<\/p>\n<p>Of the couple of things I didn&#8217;t mention because of time constraints, one was that I received an email on my phone during the day from Jeff Moss about some of his results with <em>reducing <\/em>the degree of parallelism on his system which look quite promising. He&#8217;d also had a very good tuning result on a problem query which I helped him solve. What was the extent of my expert assistance? I suggested that he might want to read the Hash Joins chapter of Jonathan&#8217;s book. He did, and found the answer. I meant to mention this to Jonathan when having a few drinks afterwards but the conversation was so intense and wide-ranging that it slipped my mind.<\/p>\n<p>Good day, great organisation and how nice it was to be able to walk home through Edinburgh on a sunny evening (with my gift of a bottle of good single malt whisky) instead of sitting around in an airport waiting to be called.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Well, to start with, it was a great venue. Perfect size, perfectly &#8216;Edinburgh&#8217; and a nice coffee\/bar area. I understand some people were freezing cold, but I think I got lucky. It was also nice to see quite a few familiar faces, including the entire Edinburgh University IT posse! (At least you can get a&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2006\/05\/10\/oug-scotland-2\/\">Continue reading <span class=\"screen-reader-text\">OUG Scotland<\/span><\/a><\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-786","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1168,"url":"http:\/\/orcldoug.com\/blog\/2007\/01\/07\/a-fresh-start\/","url_meta":{"origin":786,"position":0},"title":"A Fresh Start","date":"January 7, 2007","format":false,"excerpt":"I mentioned previously that I'll be spending January in Canada - Ottawa, to be precise. After I mentioned here that I was looking for a job, Paul Vallee of the Pythian Group contacted me to ask if I'd be interested in working for Pythian if I was able to work\u2026","rel":"","context":"With 20 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1452,"url":"http:\/\/orcldoug.com\/blog\/2008\/10\/04\/c-j-date-in-edinburgh\/","url_meta":{"origin":786,"position":1},"title":"C. J. Date in Edinburgh","date":"October 4, 2008","format":false,"excerpt":"With the help of Oracle as sponsors, Peter Robson has organised a new seminar with Chris Date in Edinburgh on 10-12th of November. The format of \"A Relational Approach to SQL\" will be two days of tutorial-like presentation from Date, followed by a Wednesday morning of discussion and debate. It\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1276,"url":"http:\/\/orcldoug.com\/blog\/2007\/06\/03\/miracle-scotland-database-forum-and-an-apology\/","url_meta":{"origin":786,"position":2},"title":"Miracle Scotland Database Forum and an Apology","date":"June 3, 2007","format":false,"excerpt":"What a week!It's a long blog posting, but it feels like it was a very long week ... I was so tired by the end of it that I can only imagine just how shattered Thomas Presslie must have been after all of the organisation. Having witnessed some of what's\u2026","rel":"","context":"With 11 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/msdbfdude.JPG","width":350,"height":200},"classes":[]},{"id":1082,"url":"http:\/\/orcldoug.com\/blog\/2006\/09\/12\/oug-scotland-2006-conference-day-1\/","url_meta":{"origin":786,"position":3},"title":"OUG Scotland 2006 Conference &#8211; Day 1","date":"September 12, 2006","format":false,"excerpt":"I originally tried to post this yesterday but lost my internet connection at a crucial moment \ud83d\ude41On Sunday evening I met up with Jeff Moss, Julian Dyke and Tom Brown in the bar of the Radisson. A few beers later, we left to meet Thomas Presslie and some of the\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":936,"url":"http:\/\/orcldoug.com\/blog\/2005\/10\/05\/oug-scotland-2005-conference\/","url_meta":{"origin":786,"position":4},"title":"OUG Scotland 2005 Conference","date":"October 5, 2005","format":false,"excerpt":"Yesterday I attended the one day OUG Scotland conference in Glasgow. I think there must have been 200-300 attendees and there were three streams of presentations. I was immediately impressed at the organisation and venue. It felt like a proper conference rather than just a slightly bigger user group meeting.After\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1620,"url":"http:\/\/orcldoug.com\/blog\/2010\/12\/05\/ukoug-2010-my-personal-account\/","url_meta":{"origin":786,"position":5},"title":"UKOUG 2010 &#8211; My Personal Account","date":"December 5, 2010","format":false,"excerpt":"I'm not sure whether I was very lucky this past week or very unlucky.DebitIt took me 14 hours to get from Edinburgh to Birmingham. That's almost a Hotsos Symposium trip!My skin condition flared up which meant I was in a thoroughly miserable mood and had to miss quite a few\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/xukoug2010_1.jpg.pagespeed.ic.OcTN1bdwhB.jpg","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/786","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"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=786"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/786\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=786"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}