{"id":796,"date":"2006-05-02T12:00:00","date_gmt":"2006-05-02T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=796"},"modified":"2006-05-02T12:00:00","modified_gmt":"2006-05-02T12:00:00","slug":"ukoug-2006-papers","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/05\/02\/ukoug-2006-papers\/","title":{"rendered":"UKOUG 2006 Papers"},"content":{"rendered":"<p>I&#8217;ve submitted two abstracts for the <a href=\"http:\/\/conference.ukoug.org\/\">UKOUG 2006 conference<\/a> in Birmingham.<\/p>\n<p>The first is just the paper that I presented in Dallas in March, Manchester last week and Edinburgh next week. It&#8217;ll be a bit like a tour for this one &#128521;<\/p>\n<p><span style=\"font-style: italic\">&#8220;How Many Slaves &#8211; Parallel Execution and the Magic of 2<\/span><\/p>\n<p> <span style=\"font-style: italic\">Several sources have suggested to me that the Magic of 2, as described by Cary Millsap, comes into play when setting the best degree of parallelism. This presentation discusses tests using various degrees of parallelism against different hardware configurations to investigate what factors should be considered when choosing an appropriate DOP.&#8221;<\/span><\/p>\n<p>The second is my attempt to address a gaping hole in my last two PX presentations. In both I hinted at trace files and wait events but didn&#8217;t really include them as much as I wanted to &#8211; mainly due to time constraints. As I&#8217;ve been working with people on different PX problems or tests, it has occurred to me that it might be worth addressing the subject properly. I don&#8217;t plan on the presentation being super-geeky, but just helpful if you ever have to trace PX jobs yourself. However, it will not include an introduction to PX, so there&#8217;ll be no padding if I can help it. (In fact, if Oracle get round to releasing 10gR2 on 32-bit Intel Solaris, I might even try to squeeze some Dtrace in there.) Anyway, here&#8217;s the abstract.<\/p>\n<p><span style=\"font-style: italic\">&#8220;Tracing PX Slaves<\/span><\/p>\n<p> <span style=\"font-style: italic\">How does the anatomy of a parallel query differ from the serial equivalent?<\/span><\/p>\n<p> <span style=\"font-style: italic\">This presentation will take a single parallel query and walk-through the tracing process and resulting trace files. As well as showing how to analyse your own parallel queries using Oracle 10g features, this will illustrate the anatomy of the query and various expected and more unusual wait events.<\/span><\/p>\n<p> <span style=\"font-style: italic\">This is not an introductory presentation, so a basic appreciation of parallel execution will be assumed, although links will be provided to supporting information.&#8221;<\/span><\/p>\n<p>A couple of final notes. First, I notice that the abstract submission deadline has been extended to this Friday, 5th May, so you still have time to make the decision to present, submit your abstract and keep your fingers crossed. Second, should anyone on the judging panel happen to read this blog, I&#8217;d rather do the tracing presentation if I had to pick one &#128521; Personally, I just hope I get a chance to present something and meet a few old and new friends while I&#8217;m there.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve submitted two abstracts for the UKOUG 2006 conference in Birmingham. The first is just the paper that I presented in Dallas in March, Manchester last week and Edinburgh next week. It&#8217;ll be a bit like a tour for this one &#128521; &#8220;How Many Slaves &#8211; Parallel Execution and the Magic of 2 Several sources&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2006\/05\/02\/ukoug-2006-papers\/\">Continue reading <span class=\"screen-reader-text\">UKOUG 2006 Papers<\/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-796","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1122,"url":"http:\/\/orcldoug.com\/blog\/2006\/11\/06\/ukoug-agenda-2\/","url_meta":{"origin":796,"position":0},"title":"UKOUG Agenda","date":"November 6, 2006","format":false,"excerpt":"Another late shift today followed a busy weekend attending an evening wedding reception on Friday and a friend's 40th birthday party in Newcastle on Saturday night, so that closing part of the Recovery Design series might have to wait for a day or two. I'm also in a growing panic\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":902,"url":"http:\/\/orcldoug.com\/blog\/2005\/11\/18\/hotsos-symposium-2006\/","url_meta":{"origin":796,"position":1},"title":"Hotsos Symposium 2006","date":"November 18, 2005","format":false,"excerpt":"My goodness, nearly a week without a blog posting and my review of Jonathan's book still hasn't appeared. It's been a crazy week at work and what little spare time I've had has been spent on getting my server installed. It looks like I won't be able to get wireless\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1076,"url":"http:\/\/orcldoug.com\/blog\/2006\/09\/04\/ukoug-2006-agenda-online\/","url_meta":{"origin":796,"position":2},"title":"UKOUG 2006 Agenda Online","date":"September 4, 2006","format":false,"excerpt":"http:\/\/conference.ukoug.org\/default.asp?p=252","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":876,"url":"http:\/\/orcldoug.com\/blog\/2006\/01\/23\/ukoug-2005-presentations-cd\/","url_meta":{"origin":796,"position":3},"title":"UKOUG 2005 Presentations CD","date":"January 23, 2006","format":false,"excerpt":"Peter Robson, one of the directors of the UKOUG asked if I'd post the following ...\"You will remember the CD that was made of some of the presentations atOUG last autumn.Could you ask, via your blog, if anyone brought a copy of this CD, andif they would be prepared to\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":923,"url":"http:\/\/orcldoug.com\/blog\/2005\/10\/31\/ukoug-2005-day-0\/","url_meta":{"origin":796,"position":4},"title":"UKOUG 2005 &#8211; Day 0","date":"October 31, 2005","format":false,"excerpt":"Well, that's the first day done. I arrived at about lunchtime and managed to attend a couple of the Oak Table presentations.The first was Anjo Kolk's - 'IO and SANS'. I've never had the pleasure of hearing Anjo present and I'm glad I made it. As well as hearing an\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":829,"url":"http:\/\/orcldoug.com\/blog\/2006\/03\/22\/ukoug-2006-call-for-papers\/","url_meta":{"origin":796,"position":5},"title":"UKOUG 2006 &#8211; Call for Papers","date":"March 22, 2006","format":false,"excerpt":"I received some timely mail when I arrived home today. Bearing in mind Howard's blog about his personal feelings about presenting at a User Group event (and it was obvious to me that he was talking about his personal feelings) and Tom Kyte's mention of it in his blog today\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\/796","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=796"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/796\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=796"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}