{"id":1357,"date":"2007-11-15T12:00:00","date_gmt":"2007-11-15T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1357"},"modified":"2007-11-15T12:00:00","modified_gmt":"2007-11-15T12:00:00","slug":"oow-day-5","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2007\/11\/15\/oow-day-5\/","title":{"rendered":"OOW Day 5"},"content":{"rendered":"<p>The final day. I didn&#8217;t wake up until 5 and had a stack of emails relating to the performance problem I&#8217;m discussing at the moment. Once I&#8217;d got through those, I bumped into APC checking out of the hotel. He&#8217;ll be on his way to the airport now. I have to offer him a big thank you, though, for reminding me of the final Real World Performance presentation at 8:30 this morning. <\/p>\n<p>What a treat, particularly from a purely selfish point of view. &#8220;When to use the appropriate database technology&#8221; was Andrew Holdsworth&#8217;s over-amibitious attempt to discuss a raft of features and where their use might help performance. I say over-ambitious, because he recognised himself how impossible that would be in an hour, so made the wise decision to limit himself to three topics.<\/p>\n<ul>\n<li>Parallel Query, Partitions and Hashing<\/li>\n<li>Optimiser<\/li>\n<li>Session and Connection Management<\/li>\n<\/ul>\n<p>Unsurprisingly, my ears pricked up at the merest mention of the first topic. Better still, he mentioned that the slides and some supporting notes will be available after the event, so I recommend you download those if you&#8217;re interested in performance.<\/p>\n<p>It was fascinating stuff and I had a strangely split reaction to it.<\/p>\n<p>a) Bl**dy h*ll, I&#8217;m going around telling people they won&#8217;t get much joy with Degrees of Parallelism much higher than single digits and these guys are using DOPs in excess of 100! That kind of blows away anything I&#8217;ve got to say on the subject.<\/p>\n<p>b) Actually,  what I&#8217;ve written about is completely true for lots of sites because, a majority of customers have 1 or 2 HBAs operating at 100MB\/sec. He described this as effectively switching off PX as a viable option.<\/p>\n<p>There was so much excellent content here that I&#8217;d rather blog or write about it properly later. I am so glad APC reminded me, because it was my presentation of the week!<\/p>\n<p>(Oh, and at least he agreed with me about not using parallel_adaptive_multi_user &#128521;)<\/p>\n<p>After that, I skipped a presentation to catch up on some blogging and then I was torn. I&#8217;d promised my current client that I would attend &#8220;Best Practices for Planning, Testing and Deploying Oracle&#8217;s CPU&#8221; because patching is becoming more important at work. However, I knew Kevin Closson was speaking at the same time and I fancied attending that. In the end, I went for the CPU presentation. I&#8217;m not sure I made the right call, but there were a few interesting bits and pieces in there and I&#8217;ll probably cascade them back to the team when I get back on-site, but too boring for inclusion here. One statement that may not have been announced yet was that 9 months after a new minor release is available (e.g. 10.2.0.4) CPUs will not be available for the previous minor release (e.g. 10.2.0.3). That sounds like yet more upgrade workload. Oh, goody! &#128577;<\/p>\n<p>Next was a burger (same place as last time!) a re-charge of my laptop and back in time for Tim Hall&#8217;s Unconference presentation &#8220;The Oracle DBA &#8211; A Dying Breed?&#8221; There&#8217;s a really good crowd, it&#8217;s a very interactive survey of the state of the DBA\/Developer relationship and, as I expected, Tim&#8217;s an energetic and funny speaker. (It&#8217;s one of the reasons I switched my schedule &#8211; I need entertainment on the last afternoon.) He even managed to withstand a barrage of loud music from across the hall. Oh, but I think he had a very modern, helpful, friendly bunch of developers and DBAs because I didn&#8217;t recognise the responses as being representative of my experience. It was like a Developer\/DBA love-in for goodness&#8217; sake! &#128521;<\/p>\n<p>Good stuff, Tim!<\/p>\n<p>After this I might catch one more presentation, then the end of conference social in the Howard Street tent, then it&#8217;s on to an Oak Table dinner kindly organised by Jared Still. I doubt there&#8217;ll be much more blogging between now and my flight home tomorrow, so that&#8217;s all for now, folks!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The final day. I didn&#8217;t wake up until 5 and had a stack of emails relating to the performance problem I&#8217;m discussing at the moment. Once I&#8217;d got through those, I bumped into APC checking out of the hotel. He&#8217;ll be on his way to the airport now. I have to offer him a big&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2007\/11\/15\/oow-day-5\/\">Continue reading <span class=\"screen-reader-text\">OOW Day 5<\/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-1357","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":837,"url":"http:\/\/orcldoug.com\/blog\/2006\/03\/10\/hotsos-2006-photos\/","url_meta":{"origin":1357,"position":0},"title":"Hotsos 2006 Photos","date":"March 10, 2006","format":false,"excerpt":"Many thanks to David Kurtz for taking photos of a much higher quality than mine and putting them on Flickr. There are some funny photos there, including a couple of Moans Nogood helping me to distribute free beer but, judging by later photos, he appears to have consumed it all\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1266,"url":"http:\/\/orcldoug.com\/blog\/2007\/05\/09\/stay-calm-ladies\/","url_meta":{"origin":1357,"position":1},"title":"Stay Calm, Ladies &#8230;","date":"May 9, 2007","format":false,"excerpt":"... and possibly gentlemen.I'm a little surprised that Thomas Presslie made the cardinal error of posting photos of the speakers at the MSDBF that will kick-off in three weeks time. I can only assume that he's prepared for the rush of Oracle groupies, clamouring to register for the remaining places.\u2026","rel":"","context":"With 17 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1041,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/31\/flatcat\/","url_meta":{"origin":1357,"position":2},"title":"Flatcat","date":"July 31, 2006","format":false,"excerpt":"Although I let Flatcat state his Loves and Hates for himself and he's the new Housemate of the Month, I couldn't leave it there.Flatcat is one of the most long-standing and valued members of the family although he's far too modest to admit it. Tigger was first but Flatcat turned\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1457,"url":"http:\/\/orcldoug.com\/blog\/2008\/12\/01\/roger-wilco\/","url_meta":{"origin":1357,"position":3},"title":"Roger Wilco","date":"December 1, 2008","format":false,"excerpt":"There's a bit of a story behind this one, so bear with me.Here's an excerpt from an email thread discussing arrangements for the Oak Table at this year's UKOUG conference. Question - Will you be bringing any employees to man the Oaktable?\u00a0 If so, they can register for exhibition only\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/xroger_ot.jpg.pagespeed.ic.hxf4ta_4Xw.jpg","width":350,"height":200},"classes":[]},{"id":975,"url":"http:\/\/orcldoug.com\/blog\/2005\/06\/08\/oug-scotland\/","url_meta":{"origin":1357,"position":4},"title":"OUG Scotland","date":"June 8, 2005","format":false,"excerpt":"I've been having a good time over the past day or two. Yesterday I gave the PX presentation to the Scottish branch of the OUG. As usual, I ran way over so I'm going to have to stop trying to 'do' PX in 45 minutes. I wasn't that happy with\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":994,"url":"http:\/\/orcldoug.com\/blog\/2006\/06\/14\/more-blogs\/","url_meta":{"origin":1357,"position":5},"title":"More blogs","date":"June 14, 2006","format":false,"excerpt":"Well, only one new blog really.Stephen Barr is a guy who I've been dealing with at work. He's a Data Warehouse specialist, part DBA, part designer, part developer. (There's a blog coming some time soon on the various Oracle roles in the modern business.) He's a contractor, too and we'll\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\/1357","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=1357"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1357\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1357"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}