{"id":1367,"date":"2007-12-08T12:00:00","date_gmt":"2007-12-08T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1367"},"modified":"2007-12-08T12:00:00","modified_gmt":"2007-12-08T12:00:00","slug":"ukoug-days-three-and-four","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2007\/12\/08\/ukoug-days-three-and-four\/","title":{"rendered":"UKOUG Days Three and Four"},"content":{"rendered":"<p>I was up pretty early on Wednesday to carry on working on my presentation. As I said to someone, once they saw how basic the content was, it would be difficult to see why it takes so long but a lot of it is tweaking with the flow and by going over it so many times in the final days, it really helps it stick in my mind.<\/p>\n<p>But nothing was going to stop me hearing Graham Wood talk about the &#8220;DB Time Performance Method&#8221;, an alternative to other methods such as YAPP and Method R. As regular readers will know, Graham is an architect at Oracle with deep involvement in the ASH, AWR and ADDM features. He talked about performance tuning in general, existing methods and how DB Time could be used instead to similar effect. He showed the various places where DB Time is exposed (and yes, he was asked a licence-related question again!) and how they could be used. The benefit of these features is that they build on existing methods but may be applicable in more situations, for example when a problem is difficult to recreate, because data collection is always enabled.<\/p>\n<p>At one point he said that he&#8217;d like to come up with a better name than the DB Time Performance Method, so if anyone has any suggestions &#8230;.<\/p>\n<p>I bumped into Marco after his presentation (it sounded like it went pretty well) but by heading along to the speaker lounge with him for a coffee, I got caught up in quite a few in-depth conversations and ended up being pretty late for the start of James Morle&#8217;s &#8220;Every Performance Problem Is One Of Two Things&#8221;.<\/p>\n<p>Those two things being Latency and Skew. I particularly liked the treatment of latency and I can only reinforce James&#8217; message that a small increase in latency can lead to a big difference in performance if it&#8217;s multiplied. This is very similar to <a href=\"http:\/\/18.133.199.212\/?p=893\">an incident I came across a while back<\/a>, involving an application design based on a very chatty app server, leading to the same wait events that James discussed. As usual, he was entertaining and funny, too, which is always a help when you&#8217;re attending a few presentations in a week. Good stuff.<\/p>\n<p>Then I knew it was time to go and hide in my hotel room to attend to my presentation and blog maintenance! I find it very difficult to work on a presentation at the conference site because there are so many people to talk to instead &#128521; By now it was coming along pretty well, but I knew that I wouldn&#8217;t be doing much more on Wednesday. I attended a tiny bit of one presentation (and thanks for the support, guys) and then went to meet the Belgians (again!) and Daniel Fink. Yet again, it was 5pm and I hadn&#8217;t eat a thing, so good on the Belgians for suggesting some food! <\/p>\n<p>After that, it was back to my room for some more prep, a quick snooze and then I realised that I hadn&#8217;t spent as much time with people as I would have liked (I only get to see some once a year), so I accepted an invitation to The Tap and Spile, which was packed to the gunnels with conference attendees &#128521; The list of Oracle faces in that pub would warrant another blog. However, I did make a point of thanking some of the <a href=\"http:\/\/public.web.cern.ch\/Public\/Welcome.html\">CERN<\/a> guys for attending. As well as the presentation I managed to attend, I heard excellent reviews of several others. These guys are just the type of top-quality contributors the User Group needs and very modest and good fun with it. I hope they become regular visitors.<\/p>\n<p>I had a couple of pints, made my excuses and left at 11:30 so I could be up early. However, I hear that some stayed there until 4:30! Now, I *know* I&#8217;m getting old, because I could never manage that! (Then again, I saw the state of them in the morning &#128521; )<\/p>\n<p>The final day dawned and all I really managed was my own presentation.<\/p>\n<p>It was one of those rare occasions when I felt good about it at the end. It *was* very light-weight technically, but I think it flowed quite well and the audience reaction was excellent. I think sometimes you need a little opinion in the presentation for people to connect with, as well as a little technical content. <\/p>\n<p><b>Updated Later<\/p>\n<p>Thanks (I think!) to Peter Robson for the following photo. I can assure you I didn&#8217;t spend the *entire* presentation with that look on my face! (and, *yes* I *do* have a red laptop)<\/b><\/p>\n<p><!-- s9ymdb:161 --><img loading=\"lazy\" decoding=\"async\" alt=\"\" height=\"480\" src=\"\/serendipity\/uploads\/OFA.jpg\" style=\"border: 0px none ; padding-left: 5px; padding-right: 5px\" width=\"640\"\/><\/p>\n<p>I was very pleased to see Graham Wood in the audience but hadn&#8217;t realised how much he had worked on OFA, as well as Cary Millsap and other guys at Oracle. That was useful, though, because he was able to clarify one or two points and afterwards we had a terrific in-depth conversation about some of the more recent history of OFA. That was one of the highlights of my week. (Oh, and Graham, it ws Nigel Thomas who asked me to say hello!)<\/p>\n<p>In fact, I had quite a few conversations with people after the presentation which is always a big part of the conference. (I was particularly pleased to see someone who attended my presentation had already downloaded Cary&#8217;s OFA paper to his PDA to read on the trip home &#8211; mission accomplished!) Unfortunately, it also meant that I had a toss-up between lunch (hadn&#8217;t eaten again) and Jonathan Lewis&#8217; Masterclass. The stomach won. Then it was off to the airport and back home.<\/p>\n<p>I wish I&#8217;d had time for more fun and learning during the conference. In future, although I know I can work on a presentation during a conference (useful if life has been busy in the lead-up), it&#8217;s definitely not the best approach. A few tweaks, maybe, but not the entire presentation &#128521;<\/p>\n<p>It was still a good week, though.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was up pretty early on Wednesday to carry on working on my presentation. As I said to someone, once they saw how basic the content was, it would be difficult to see why it takes so long but a lot of it is tweaking with the flow and by going over it so many&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2007\/12\/08\/ukoug-days-three-and-four\/\">Continue reading <span class=\"screen-reader-text\">UKOUG Days Three and Four<\/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-1367","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1429,"url":"http:\/\/orcldoug.com\/blog\/2008\/08\/20\/time-matters-db-time\/","url_meta":{"origin":1367,"position":0},"title":"Time Matters &#8211; DB Time","date":"August 20, 2008","format":false,"excerpt":"[In retrospect, the title of that first blog post might have suited the subject, but doesn't translate too well for subsequent related blog posts. That was a lack of planning or foresight on my part. These blog posts are tumbling out of my head in a fairly incoherent way. Maybe\u2026","rel":"","context":"With 13 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1432,"url":"http:\/\/orcldoug.com\/blog\/2008\/09\/01\/time-matters-db-cpu\/","url_meta":{"origin":1367,"position":1},"title":"Time Matters &#8211; DB CPU","date":"September 1, 2008","format":false,"excerpt":"In his comment on the last post, John Beresniewicz mentioned the following property of DB CPU :-\"... 'DB time' fully contains 'DB CPU' and both are measured values (which means in particular that 'DB CPU' is not inflated by runq time)\"I'd like to talk about the end of that sentence\u2026","rel":"","context":"With 24 comments","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/18.133.199.212\/wp-content\/uploads\/recovered\/DBCPU4.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1720,"url":"http:\/\/orcldoug.com\/blog\/2014\/08\/05\/get-up-offa-that-thing\/","url_meta":{"origin":1367,"position":2},"title":"Get Up Offa That Thing","date":"August 5, 2014","format":false,"excerpt":"No, no, no ... not *that* JB! As regular readers will know, the JB who tends to get mentioned most often around these parts is John Beresniewicz who, up until recently, worked at Oracle on all the cool OEM Performance Pages and related instrumentation (alongside others, of course, such as\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1658,"url":"http:\/\/orcldoug.com\/blog\/2011\/11\/07\/upcoming-ukoug-conference\/","url_meta":{"origin":1367,"position":3},"title":"Upcoming UKOUG Conference","date":"November 7, 2011","format":false,"excerpt":"I always look forward to this time of year as the annual UKOUG conference in Birmingham approaches but this year I think I'm looking forward to it more than ever.As I'll have delivered both of my own presentations at previous events my slides will be done before I arrive and\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":938,"url":"http:\/\/orcldoug.com\/blog\/2005\/09\/29\/html-db\/","url_meta":{"origin":1367,"position":4},"title":"HTML DB","date":"September 29, 2005","format":false,"excerpt":"Today I had one of those minor buzzes of excitement when I started to play around with Oracle's hosted HTML DB environment.Without wanting to go into my current feelings about work, you could say things are a little quiet. I'm trying to find things to do but I've joined just\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1480,"url":"http:\/\/orcldoug.com\/blog\/2009\/03\/31\/diagnosing-locking-problems-using-ash-part-3\/","url_meta":{"origin":1367,"position":5},"title":"Diagnosing Locking Problems using ASH &#8211; Part 3","date":"March 31, 2009","format":false,"excerpt":"Some features in this post require a Diagnostics Pack license.In the last part I described a locking scenario where the blocking session had only executed one SQL statement that was quick enough to avoid being sampled by ASH and is now inactive. As a result, there is no ASH data\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1367","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=1367"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1367\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1367"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}