{"id":1638,"date":"2011-05-20T12:00:00","date_gmt":"2011-05-20T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1638"},"modified":"2011-05-20T12:00:00","modified_gmt":"2011-05-20T12:00:00","slug":"a-day-of-real-world-performance","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2011\/05\/20\/a-day-of-real-world-performance\/","title":{"rendered":"A Day of Real World Performance"},"content":{"rendered":"

Tuesday was a fun day this week as Graham Wood, Tom Kyte and Andrew Holdsworth visited London for the latest Real World <\/p>\n

Performance Day<\/a>. <\/p>\n

This is an event that has already run several times in the US via the IOUG and consists of a three-person presentation style which I thought worked very well – much better than I expected it to if I’m honest. Each presenter played a different role and often there were slightly different perspectives. Truth be told, I have quite a low boredom threshold sometimes and even with the long presentation slots I didn’t find myself drifting off. Multiple top-notch speakers definitely helped.<\/p>\n

Regular readers of this blog will be very familiar with most of these chaps. Perhaps less so Andrew Holdsworth who heads up the Real World Performance group at Oracle. If you attend Oracle Openworld you’ll be familiar with him but I’m not sure I’ve ever seen him present in the UK. A lot of the slides would have been familiar to OOW Real World Performance presentation attendees too but, although I might not have learned too much, I preferred the way it was presented here. The day was split up into Data Warehouse-focussed material in the morning and OLTP in the afternoon, which was a useful way of covering a lot of topics whilst highlighting different performance goals. <\/p>\n

As most of the people from my current site who attended are predominantly focussed on DW, the morning probably proved more useful. The only slight criticism I might make is that, despite the fact that Andrew was very clear that the first step that everything else was predicated on should be a balanced hardware configuration with enough power, that was easy to forget as the morning went on. So I heard a few people bemoaning the fact that all of the demos were on Exadata and so they wanted to know how much of the stunning improvements were down to Exadata and how much to the approaches used. Personally, I didn’t think the absolute numbers mattered so much as the principles illustrated and I thought it was clear that enough power in a balanced configuration was the foundation, whether that’s Exadata or (heaven help us!) another platform 😉<\/p>\n

My feeling was that this might not be everyone’s Real World Performance on the systems that they’re working on which is what perhaps confused people, but was the performance that *should* be possible in the real world if you buy enough kit and use the correct approach. If you’ve worked on badly configured systems, your own experience might be very different to what’s achievable these days. To give you an example, it probably is the case these days that your data loads should be CPU-bound and that compression should be what’s limiting your throughput, but that’s predicated on not having a useless storage subsystem. I can certainly recall situations where loads were I\/O bound so compression was used to speed the loads up and they were *still* I\/O bound. <\/p>\n

By always keeping in mind ‘this is what we should be aiming for’, I thought it was all very useful and achievable. Perhaps worth reminding people a little more often that some of the techniques might not deliver if your configuration is wrong but, I repeat, Andrew was very clear that this is the *first* step.<\/p>\n

Sadly if you insist that all of your data has to be fed in through Java application servers that pretty much undermines a lot of the morning content, around the Terabyte data loading exercise, but all you can do is try to lead people in the right direction!<\/p>\n

One aspect of the Real World Performance presentations I’ve always appreciated is that they discuss ball-park expectations you should have of different system components and configurations. I know from personal experience of teaching performance courses that many people lack this information and are hungry for it. Fortunately the material is publicly available in a zip file<\/a> on Tom’s site<\/a> so I don’t <\/p>\n

need to cover the technical details.<\/p>\n

(Note, however, that this is just the slide material and doesn’t cover the demos, the questions and answers and dialogue so it’s a poor substitute for the experience of attending.)<\/p>\n

There’s much more I could say about the day. I know a couple of colleagues who enjoyed it as much as I did and found it useful (some more than others) to the extent that I think they might be attending a few more conferences in future if they’re this good<\/p>\n

Congratulations to all involved and I’ll finish with a piece of good news for those who missed it. According to Thomas Presslie (@tpresslie) there will be another run of the same event in Edinburgh on the 23rd August 2011. Not to be missed!<\/p>\n","protected":false},"excerpt":{"rendered":"

Tuesday was a fun day this week as Graham Wood, Tom Kyte and Andrew Holdsworth visited London for the latest Real World Performance Day. This is an event that has already run several times in the US via the IOUG and consists of a three-person presentation style which I thought worked very well – much… Continue reading A Day of Real World Performance<\/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-1638","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1643,"url":"http:\/\/orcldoug.com\/blog\/2011\/07\/21\/its-over-kind-of\/","url_meta":{"origin":1638,"position":0},"title":"It’s over, kind of","date":"July 21, 2011","format":false,"excerpt":"(No, not the blogging.)The fact that I'm writing this post from my new home in London, rather than a hotel room or an airport lounge, should mean that the move from Edinburgh to London is done. If only it was that simple. As with any move, new things to take\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1530,"url":"http:\/\/orcldoug.com\/blog\/2009\/10\/14\/oow-2009-tuesday\/","url_meta":{"origin":1638,"position":1},"title":"OOW 2009 – Tuesday","date":"October 14, 2009","format":false,"excerpt":"Another good day although it didn't go quite as I planned it, but that's part of the fun of a good conference. Should I mention at this point that I have a cold? I certainly noticed it this morning \ud83d\ude41I got moving eventually and my first session was \"The Life\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1535,"url":"http:\/\/orcldoug.com\/blog\/2009\/10\/16\/oow-2009-thursday\/","url_meta":{"origin":1638,"position":2},"title":"OOW 2009 – Thursday","date":"October 16, 2009","format":false,"excerpt":"My Unconference presentation slot was at 10:00 and in addition to Kevin Closson's 9:00 slot being cancelled, I noticed that there was absolutely no one in 'my room' so it looked like a presentation fell through due to lack of attendees \ud83d\ude41 Not a promising start and there definitely needs\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1727,"url":"http:\/\/orcldoug.com\/blog\/2014\/10\/08\/oow-2014-day-2\/","url_meta":{"origin":1638,"position":3},"title":"OOW 2014: Day 2","date":"October 8, 2014","format":false,"excerpt":"Disclosure: I'm attending Openworld at the invitation of the OTN ACE Director program who are paying for my flights, hotel and conference fee. My employer has helpfully let me attend on work time, as well as sending other team mates because they recognise the educational value of attending. Despite that,\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1670,"url":"http:\/\/orcldoug.com\/blog\/2012\/01\/16\/upcoming-conferences\/","url_meta":{"origin":1638,"position":4},"title":"Upcoming Conferences","date":"January 16, 2012","format":false,"excerpt":"At this time of year, I'm usually panicking about my Hotsos presentation\/paper and up to my eyeballs in test scripts. I enjoy it and the absence feels a little strange, but I decided to do something different this year. Although it's the 10th Symposium and I'm sure it will be\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1439,"url":"http:\/\/orcldoug.com\/blog\/2008\/09\/22\/oow-day-2\/","url_meta":{"origin":1638,"position":5},"title":"OOW Day 2","date":"September 22, 2008","format":false,"excerpt":"Wow, it's hot and sunny here! I keep forgetting, so I'm still wondering around with a jacket in tow. That'll be getting dumped at the hotel later.Today's been a quieter day so far, but no less enjoyable for that. After making a lazy start, I thought I'd check out the\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\/1638","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=1638"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1638\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1638"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}