Jun 6: OUGN Conference 2012
I'm going to kick off this post by really blowing my own trumpet! There have been times (perhaps not many) when I've heard that posts here have influenced others and helped them make decisions. That always catches me by surprise (erm, I suppose I should stop being surprised by now), but it's brilliant too. One example is that I've met several people who first considered working for Pythian because my blog post about their interview process stuck in their minds. Of course, people like Paul Vallee and Alex Gorbachev are master recruiters, too, but I did my bit in some cases.
Then there's my post about last year's OUGN conference. I was so positive about it that I believe it influenced some speakers to attend for the first time and, as I expected, all seemed to have a great time - even if you might question how many Martins a conference needs and allow for Martin Widlake and Maria Colgan having to be loaded on sea-sickness pills. (Martin didn't seem to be his usual excitable self so, erm, I might suggest they're useful on land too. Oracle London Beer attendees would confirm that the main challenge is to get Martin and I to shut up for a few seconds so others can get a word in occasionally! )
Already looking forward to the event, I was expecting an even better time from being able to spend some more time with friends that I don't get to see often enough and so it proved.
This year's conference was the first time that OUGN organised an additional first day on dry land before setting sail which allowed them to pack the agenda with even more good content. I skipped this, just to avoid taking another day out of the office, but it meant that by the time I turned up late in the evening, some friends had already had a good first day and an excellent night out. For the record, I was neither surprised by how popular the two Martins RAC Attack was, nor by how they found Norwegian hospitality! Of course, despite an early start, a long day at work and my trip, I still couldn't resist one too many beers in the top floor bar of a hotel with a great view of Oslo particularly once a few friends showed up. With so much to talk about, it went on a little later than I'd planned (Then again, a regular reader might challenge the veracity of any of these 'plans' I keep mentioning.)
... which meant that I woke up a little later and it was all a bit rushed getting my act together and making my way towards the ferry terminal for registration, which was as packed and excitable as I remembered from last year. The long opening keynote session was split into multiple sections, some of them in Norwegian (reasonably enough!) so there was a small huddle of speakers at the back of the show theatre, tapping away on their laptops, but Andrew Sutherland's "Simplify IT" section sparked my interest a little, primarily because he's a very captivating speaker!
Eventually, though, it was time for the mass migration to our different rooms for the trip, a little much-needed lunch and then I was in my usual pre-presentation getting-cleaned-up-and-panicking mode. Which meant that I missed Jonathan Lewis' session on Desgining Optimal SQL. In fact, Jonathan was speaking immediately before both of my presentations, which meant I not only missed both sessions but (cough!) ended up with practically no setup time, which made me a little more nervous than usual. I was even more nervous when the front row included Oracle University instructors Uwe Hesse and Harald Van Breederode. As an ex-instructor myself and from their blogs, I know these guys really know their stuff and, of course, Maria Colgan was hiding at the back, waiting for me to say something stupid In the end, I could tell I hadn't done as well as usual but was almost relieved to get to the (rather hurried) end.
It's not my favourite presentation material in any case and I was feeling on particularly poor form, so I was gutted when I found out that it had been recorded It took me a long time to bring myself to watch it, I didn't enjoy it and I've considered about 42 times whether to post a link. I've decided to, with several caveats
- I still really don't like this presentation and don't plan to give it again, but conference submissions are agreed months in advance, before the presentations are even written.
- I've been going through a minor crisis over talking to my mates, introductions and other presentation details which are nothing to do with the technical content. I think I've probably come up with some solutions, but this is a mid-way point in that process. That is code for - skip the first 6 or 7 minutes if you can't be bothered with me waffling on about nothing at all! (Thanks to Boneist for pointing this out although I have to say some people in the audience seemed to enjoy it, others probably didn't at all)
- I'm still not convinced that watching presentations online is as good as the real thing. I haven't put my finger on why yet but, even a presentation like Cary Millsap's UKOUG keynote which I utterly enjoyed live didn't seem as good when I watched videos later.
- Erm, I really don't like it and know I can be much better. For example, it's very unlike me to read my slides so much. Sigh
Anyway, the turning point in me deciding to post the link is that I really like the delivery platform and there are a bunch of presentations here for free that means you can enjoy some of being at a conference without the time off work and the conference registration fee. I just wish they'd recorded my other presentation, which I preferred
After that, despite an aborted attempt to listen to one presentation, I was probably just about ready to crash out and rest for a while but the company and atmosphere is so positive on the boat that it's very hard not to find yourself moving on from one drink and conversation to another in a seamless blur before sitting down to a proper dinner with other presenters and attendees. I honestly can't remember the seperate details of the two evenings but the first was probably a little more sedate as I still had a demo-packed presentation to take care of the next morning ....
I spent Jonathan Lewis' double presentation working through my demos one last time and then pacing around outside waiting for the man to shut up! Fortunately there was a smoking room right next to the presentation auditorium However, by the time I was able to plug-in I only had 5 mins to make sure everything was ok and, sure enough, had to go through another reboot cycle to get the VM driving the projector properly. (Note for potential new presenters. I always allow myself *more* than enough time because nothing puts the wind up you like having to solve some equipment issue as you're starting to speak. Even if you manage to pull it off, and you probably will, it affects your balance for the early part of the presentation. That's my experience, anyway.)
So I wish the demonstrations had been a bit better and I wasn't quite so flustered, but I love showing the OEM 12c Performance Pages so much that I hope my enthusiasm came through and I much preferred this one. I probably spent a little too long on the original Top Activity Page for those who had already seen it, but it's difficult to do ASH Analytics without being sure people know the fundamentals first. The Red Gate webinars will solve that by allowing me two sessions. I was pretty surprised by how many people showed up, because I was speaking in the slot when people can go ashore in Kiel to stretch their legs and grab lunch. In the end, a few of us managed to hop off the boat immediately after my session although it was a bit of a rush to make sure we weren't left behind!
After lunch was a sort of talk show/panel session, diving into some of the more personal aspects of some of the main speakers personalities. It was ok, but part of me thinks we should have just dragged them all off to the Monkey Bar, bought them all a drink and we would have probably learned more about them That was followed by a comedy show by Norwegian star Åsleik Engmark. I honestly can't tell you whether it was funny, but several of my Norwegian friends seemed to love it.
By now I was so bushed that I had to sit at the front of "Tips to Prevent suboptimal Execution Plans" by Maria Colgan so that I knew I wouldn't dare nod off or start snoring! She was great, as usual, but it was really tough listening to anyone at that point and so from then on it was just one last night of drinking, eating and partying, culminating in the (smoking) Night Club. Bliss
I didn't manage to sleep in quite so badly as I did last year, but I just had time to get ready before popping off the boat and taking the bus to the train station that OUGN had organised for speakers. Yet another excellent touch.
As we were a little early, some Martins and I spent a last little time with Oyvend Isene before heading off to the airport where it was, frankly, Martin Central. One of my lasting memories will be of Martin Nash, having been warned about the possible hot dog contents, bit into his and splattered me with the insides. The look of horror on his face won't leave me in a hurry. The cleaning bill is in the post
I said it last year and I'll say it again. OUGN is one of my favourite conferences. Everyone I know seemed to have a great time and I'm convinced that, although being on the boat is a big factor, perhaps the Norwegians are a bigger factor. To make a few sweeping generalisations based on a very small sample ... humble, funny, clever and occasionally a little cynical - it's like being around Scots who have a healthier diet and speak a different language
OUGN know how to organise a great conference and treat speakers so well that it's a real pleasure to go there and one that I'm looking forward to repeating. In fact, I received this from one of the organisers, Truls Bergersen
"Next year's OUGN Seminar will be Wednesday to Saturday April 17th-20th or 24th-27th 2013. We're awaiting the sailing plan from Color Line to know which of these two weeks that the Color Magic departs from Oslo on a Thursday. The format of the 3-day seminar will be very similar to this year: Wednesday on shore, and Thursday to Saturday on Color Magic."
If you get a chance to attend, you probably won't be disappointed. Oh, and if this post influenced you and you enjoy it - I reckon you owe me a beer
I watched the video - seems good to me, don't know what you're fussing about.
I see what you mean about the delivery platform - very slick.
Listening to what you were saying, talking about stable performance, got me reflecting...
I see a regular trickle of isolated process performance problems caused by plan changes, but it's really just a trickle (and in that regard, I'm really not convinced by the cardinality feedback feature - it seems to be a frequent factor).
But once a week I seem to be looking into system performance problems and, for example, slow batch processes that are caused by significant variations in SAN response times.
Even variations that are within SLA times - for example, taking a one hour AWR report covering a core multi-process batch window, if single block IO reads average 2 ms one day and 4 ms the next then that can actually be quite significant, let alone when that 2 ms goes beyond SLA to an average of 10ms.
Similarly, for a commit-heavy workload, if my log file syncs go from 4-5 ms to 30-40ms, all my concurrent commit workload is going to feel that.
Maybe it's different on a dedicated platform like Exadata or ODA where the whole stack is isolated from external influences and maybe that's one of their big strengths.
So... and I'm losing focus on what I want to say... plan stability is great, plan stability features are great but for example, internally at my client I see a lot of importance attached to plan stability and yet a huge reluctance to embrace plan stability features... And an obsession with performance problems being caused by plan instability ("plan flip"=bad?) when actually if I spend multiples of time doing my IO today compared to yesterday, then that's a problem...
Apologies for the sluggish reply but I don't seem to have received a notification mail for this comment for some reason - just the occasional spam comment recently.
I think what you're saying is probably very site-specific. The team I've just left, although we had occasional issues of the type you've described, they were pretty rare which I put down to having a few great storage specialists and good configurations.
Plan changes, on the other hand, we would have left, right and centre, for a variety of reasons, including some less than stellar approaches to stats collection, frequent stats collection, constantly evolving literal values etc etc etc. That's why were constantly looking at plan stability features and why most of the applications were awash with hints.
I suppose whatever a sites particular problem profile tends to be, there are plenty of issues around to keep us busy