{"id":1460,"date":"2008-12-05T12:00:00","date_gmt":"2008-12-05T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1460"},"modified":"2008-12-05T12:00:00","modified_gmt":"2008-12-05T12:00:00","slug":"ukoug-day-3","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2008\/12\/05\/ukoug-day-3\/","title":{"rendered":"UKOUG Day 3"},"content":{"rendered":"

After more work on the presentation and some very strange sleeping hours thanks to the raucuous ranks on Broad Street, it was time for the first of my presentations. But before that I wanted to attend JB’s “Proactive Detection of Oracle Performance Events using Adaptive Thresholds” (skipped), the always entertaining Mogens Norgaard’s “The Danish Experiment: 11g-Shock Upgrades and Massive Workload Reduction via C.O.B.S. (TM)” which was good if a little short (more on APC’s blog<\/a>) and H\u00fcsn\u00fc \u015eensoy’s “Backup and Recovery Tuning for VLDBs”, which was cancelled. I was particularly disappointed about the two missing presentations because JB’s stuff was probably relevant to my course and I’m currently involved in designing a Backup and Recovery strategy for a big new DW that’s planned at my current site. On the other hand, it gave me a little more time to get ready for presentation and chill out a little.<\/p>\n

Marco Gralike chaired the session and was good enough to bring a gift of this little chap.<\/p>\n

\"\"<\/p>\n

Apparently he was keeping him awake all night by watching MTV in Marco’s hotel room. I didn’t really understand this story properly until later on Wednesday night when the little guy spent all night watching MTV in *my* room 🙁<\/p>\n

I was unusually pleased with my “Performance Tuning Basics” presentation. It was definitely a push squeezing it into 45 minutes as best I could and there were definitely a couple of things that didn’t go as I’d hoped but, fundamentally, it was one of those good days. It was an introductory presentation and so it was difficult to go into anything in too much depth, but I think that sometimes it’s the basic approach that people get wrong, rather than the technical stuff and that was the main message I wanted to get across. One problem was that I had a good couple of demos which would have helped reinforced some of the points, but there just wasn’t enough time. Another was that I’d planned to promote the DBA 2.0 session after mine because I knew those guys would show some of the Performance Pages in DB\/Grid Control that I didn’t have time to show. Although I’d checked this before the presentation, I only remembered when they came on stage at the end to set up. Graham Wood and JB were very nice about my presentation, though, which was comforting as they’re two of the guys who design this stuff! In fact, later that evening, people kept coming up to me to tell me that they had both been very positive about my session during their own, which I was really pleased to hear. Maybe I should have attended DBA 2.0? Actually, hearing Marco’s verdict afterwards, maybe not! I’ll leave it to Marco to put his money where his mouth is 😉 (Updated later … Marco has posted his thoughts<\/a> on the presentation now.)<\/b><\/p>\n

There was one other small correction that Niall Litchfield<\/a> pointed out to me post-presentation. I think he’s right, but I’m going to check it out at home before I upload the slides. (Updated later … Niall was right. As described in ‘Tales of the Oak Table’, it was as a result of a problem with a benchmark, rather than a customer problem, that the wait instrumentation was introduced but I think I had the correct time-frame at least. I’ve replaced ‘When faced with a customer problem …’ with ‘When faced with a benchmark problem and uploaded the slides to the UKOUG website. Frankly they’re very visual and content-light, though.)<\/b><\/p>\n

A quick dash and I was off to listen to Steve Shaw of Intel talking about “Benchmarking Parallel Query Performance”. I have a clear interest in the subject, both from a load-testing and PX perspective, so it was pretty interesting for me. I liked the closing line – ‘Don’t guess, test’ – if I recall correctly, but my favourite bit was probably that he was another guy (like Eric Grancher yesterday) who had been able to test on Exadata. His findings on a TPC-H-like test (and it’s very important to state that it’s only a representation) using HammerOra was that Exadata produced a 5-10 times performance improvement over his Fibre-Channel SAN configuration and that it had changed the game completely for Oracle Data Warehouses. Now, whilst I hestitate to make such a bold, unqualified statement in a blog post, he was clearly very impressed, having actually worked with the thing. Maybe I’ll need to go out busking (for a *long* time) to get the pennies together to buy one for my current client.<\/p>\n

After that it was the main UKOUG party night but I’d have to say at the risk of sounding repetitive that the whole event seemed much quieter this year so it was a bit of a damp squib from my perspective so I didn’t stay out too long because I had another presentation to prepare for in the morning. They announced the newly-appointed Directors whilst I was having a smoke outside but I heard that Lisa Dobson<\/a> was voted in when I got back upstairs. Congratulations, Lisa 😉<\/p>\n

P.S. I had extremely sore calf muscles when I woke up on Wednesday morning. It took me about 30 seconds puzzling why that might be before I remembered running up and down stairs during James Morle’s presentation!<\/p>\n","protected":false},"excerpt":{"rendered":"

After more work on the presentation and some very strange sleeping hours thanks to the raucuous ranks on Broad Street, it was time for the first of my presentations. But before that I wanted to attend JB’s “Proactive Detection of Oracle Performance Events using Adaptive Thresholds” (skipped), the always entertaining Mogens Norgaard’s “The Danish Experiment:… Continue reading UKOUG Day 3<\/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-1460","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1669,"url":"http:\/\/orcldoug.com\/blog\/2012\/01\/10\/ukoug-2011-ash-outliers\/","url_meta":{"origin":1460,"position":0},"title":"UKOUG 2011 – Ash Outliers","date":"January 10, 2012","format":false,"excerpt":"My final UKOUG 2011 post is about another of my favourite presentations -\u00a0 \"ASH Outliers: Detecting Unusual Events in Active Session History\" by John Beresniewicz. (JB for short, but Marco Gralike made a fairly good stab at pronouncing his surname correctly during the introduction.)I'd been looking forward to this presentation\u2026","rel":"","context":"With 11 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1487,"url":"http:\/\/orcldoug.com\/blog\/2009\/04\/20\/diagnosing-locking-problems-using-ash-part-6\/","url_meta":{"origin":1460,"position":1},"title":"Diagnosing Locking Problems using ASH \u2013 Part 6","date":"April 20, 2009","format":false,"excerpt":"\"Toto, I've a feeling we're not in Kansas any more.\"What started as a simple write-up of a course demo gone wrong (or right, depending the way you look at these things) has grown arms and legs and staggered away from the original intention to talk about ASH. so I thought\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1077,"url":"http:\/\/orcldoug.com\/blog\/2006\/09\/06\/presentations-completed-and-to-come\/","url_meta":{"origin":1460,"position":2},"title":"Presentations completed and to come","date":"September 6, 2006","format":false,"excerpt":"Yesterday was the developer training\/seminar that I mentioned in an earlier blog. It was okay I suppose but I made a bad decision to drop analytics because I didn't feel I could do them justice in the available time. Then I finished half an hour early \ud83d\ude41 Based on verbal\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1719,"url":"http:\/\/orcldoug.com\/blog\/2014\/07\/24\/recurring-conversations-awr-intervals-part-2\/","url_meta":{"origin":1460,"position":3},"title":"Recurring Conversations: AWR Intervals (Part 2)","date":"July 24, 2014","format":false,"excerpt":"(Reminder, just in case we still need it, that the use of features in this post require Diagnostics Pack license.) Damn me for taking so long to write blog posts these days. By the time I get around to them, certain very knowledgeable people have commented on part 1 and\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1429,"url":"http:\/\/orcldoug.com\/blog\/2008\/08\/20\/time-matters-db-time\/","url_meta":{"origin":1460,"position":4},"title":"Time Matters – 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":1325,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/27\/i-was-a-danish-stunt-double\/","url_meta":{"origin":1460,"position":5},"title":"I was a Danish Stunt Double","date":"September 27, 2007","format":false,"excerpt":"... or is it a Scottish Stunt Double? I'm not sure. I had originally planned to attend only the afternoon part of next week's OUG Scotland conference. That way I would be able to spend the morning in work and still catch a few presentations I want to see. However,\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1460","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=1460"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1460\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1460"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}