{"id":1353,"date":"2007-11-15T12:00:00","date_gmt":"2007-11-15T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1353"},"modified":"2007-11-15T12:00:00","modified_gmt":"2007-11-15T12:00:00","slug":"oow-day-4-performance-day","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2007\/11\/15\/oow-day-4-performance-day\/","title":{"rendered":"OOW – Day 4 – Performance Day"},"content":{"rendered":"

Yesterday was the best day so far, particularly the morning. To start with, I was feeling a little more human (although still out of bed at 4am). I managed to squeeze in breakfast with APC, three conference sessions and a lovely burger for lunch 😉<\/p>\n

First was Jonathan Schwartz’s keynote. You’ll have read plenty about that elsewhere, but it was notable for Dell announcing Solaris support and yet another virtualisation announcement. I realise this is a hot topic for most businesses at the moment, but there’s a strong sense of the ‘me, too’ about it. Anyway, head over to openxVM<\/a> and see what you make of it. My strongest impression of this presentation was the contrast to the Sun keynote in 2000, given by Scott McNealy. I remember being really disappointed by Scott’s home-spun style, even though some like it, and I found Jonathan a much more attractive proposition with my business hat on. I know it’s about substance and not just style and I sense he’s not the most popular guy, but at least I felt like he’d actually prepared for the presentation!<\/p>\n

After that, it was off to the first of three sessions I’m attending this week coming out of the Real World Performance group at Oracle (in fact I’m typing this while I sit and wait for the last one to start). <\/p>\n

Andrew Holdsworth’s “Current Trends in Database Performance” was right up my street. It was a mild rant against the performance problems he sees at customer sites and during customer benchmarks. The more he said, the more I recognised things I tend to rant about myself. For example, most applications are implemented sub-optimally but, with the increased power of CPUs and availability of memory, people often just don’t notice a problem. That’s fine as far as it goes, but when you do hit a problem you’re constrained by a badly written application or, worse still, a badly designed data model that eliminates any hope you have of writing an optimal application! <\/p>\n

He talked about the difficulty of building a representative workload for capacity planning and benchmarking, which is a subject that’s cropped up here<\/a> in the past and I have on my list to revisit at some point.<\/p>\n

But my favourite part was when he talked about implementing balanced<\/i> systems. What I see in my travels, outside the stratosphere of Oracle’s internal work and top-end customers is that sites simply don’t have enough I\/O bandwidth to match their other hardware resources. That cropped up again in Thursday morning’s presentation too, so I’ll come back to it later, but I don’t doubt for a second that the Oracle Optimised Warehouse Intitiative springs from this gaping wound in customer system architecture.<\/p>\n

Oh, no, I’m wrong. My favourite<\/i> section was a discussion of how an anti-social instance can cause great pain to everyone who is using a server. A great argument for a single instance per server and I speak as someone who has just been involved with an anti-social instance! (Although in that case it’s been eased by implementing AIX WLM (workload management) on it.)<\/p>\n

The next session was the Real World Performance Group Round Table session, with Andrew (again), Mike (?), Graham Wood, Greg Rahn<\/a> and the product manager. With so many bright minds on display, it was just what I was looking for and it was nice of Graham to come and say hi before they got down to business. <\/p>\n

God, there was so much in this session it’s difficult to know what to pick out, but it looks like cursor_sharing=similar should be improved in 11g according to Graham. Greg Rahn talked about how often query plan problems can be solved quickly by using dbms_xplan.display_cursor to compare estimated and actual cardinalities. Greg’s obviously a really smart guy and it was a shame I hadn’t put a name to the face when I met him in Chevy’s the other day because I’m quite an admirer of his work so it would have been nice to meet him properly. He also highlighted the much-improved Auto-sampling code in 11g which should give very estimates in a reasonable time. <\/p>\n

My best suggestion is that if you get a chance to hear these guys present or discuss performance with them, bite their hands off! Good stuff.<\/p>\n

I’ll write about yesterday afternoon and evening a bit later.<\/p>\n","protected":false},"excerpt":{"rendered":"

Yesterday was the best day so far, particularly the morning. To start with, I was feeling a little more human (although still out of bed at 4am). I managed to squeeze in breakfast with APC, three conference sessions and a lovely burger for lunch 😉 First was Jonathan Schwartz’s keynote. You’ll have read plenty about… Continue reading OOW – Day 4 – Performance Day<\/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-1353","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1525,"url":"http:\/\/orcldoug.com\/blog\/2009\/10\/12\/oow-2009-the-jonathan-lewis-comedy-hour\/","url_meta":{"origin":1353,"position":0},"title":"OOW 2009 – The Jonathan Lewis Comedy Hour","date":"October 12, 2009","format":false,"excerpt":"Well, it's definitely a cold. Made it to bed just after 1 after a party which had convinced me I was feeling better, only to wake up stuffed with the cold, completely convinced that I'd slept in. It was 4:45 \ud83d\ude41 Bizarrely, I feel fully refreshed sleep-wise, but blocked up\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/xoakribbon1.jpg.pagespeed.ic.3zERKY-0YZ.jpg","width":350,"height":200},"classes":[]},{"id":922,"url":"http:\/\/orcldoug.com\/blog\/2005\/10\/31\/ukoug-2005-day-1\/","url_meta":{"origin":1353,"position":1},"title":"UKOUG 2005 – Day 1","date":"October 31, 2005","format":false,"excerpt":"Well, after a power cut in Central Birmingham that delayed the start of the conference by about an hour, things are moving along nicely. The presentations that I've attended so far are :-Tom Kyte's SQL techniques. As excellent as I expected and I preferred Tom's presentation technique to last years\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1672,"url":"http:\/\/orcldoug.com\/blog\/2012\/01\/09\/ukoug-2011-cary-millsaps-keynote-videos\/","url_meta":{"origin":1353,"position":2},"title":"UKOUG 2011 – Cary Millsap’s Keynote Videos","date":"January 9, 2012","format":false,"excerpt":"I noticed last week that the keynote presentation I discussed in a previous post is available on YouTube, in 5 parts ....Part 0Part 1Part 2Part 3Part 4It was a strange experience watching it again because, although I recognise it as precisely the same presentation, it didn't have as much impact\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1618,"url":"http:\/\/orcldoug.com\/blog\/2010\/11\/21\/conference-update\/","url_meta":{"origin":1353,"position":3},"title":"Conference Update","date":"November 21, 2010","format":false,"excerpt":"The week before the UKOUG conference (or more accurately - UKOUG Conference Series Technology and E-Business Suite 2010. Maybe I'll just stick to UKOUG) and whilst it's an unusual year in as much as I'm not presenting some traditions hold true. I have a stinking cold - my third in\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1440,"url":"http:\/\/orcldoug.com\/blog\/2008\/09\/23\/oow-day-3\/","url_meta":{"origin":1353,"position":4},"title":"OOW Day 3","date":"September 23, 2008","format":false,"excerpt":"Well, 2.5 too, I suppose. I spent most of Monday afternoon 'networking'. i.e. Sitting around the OTN lounge chatting away to several people I know, most of them the strange old gents who like to complain about things a lot \ud83d\ude09I did, however, attend Andy Mendelsohn's General Session, or keynote\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1687,"url":"http:\/\/orcldoug.com\/blog\/2012\/09\/04\/enkitec-extreme-exadata-expo\/","url_meta":{"origin":1353,"position":5},"title":"Enkitec Extreme Exadata Expo","date":"September 4, 2012","format":false,"excerpt":"(Otherwise known as #E4)Another late post, but a few weeks ago I had the pleasure of attending and speaking at Enkitec's dedicated Exadata conference, E4. The stand-out impressions that I've been babbling away to people about since getting home were :-1) The uniformly good quality of the presentations I was\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/18.133.199.212\/wp-content\/uploads\/recovered\/JL.png?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1353","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=1353"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1353\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1353"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}