Day 2 started with a very tired Doug Burns presenting “Performance and Stability with Oracle Database 11g’s SQL Plan Management”. As with his previous talk, this was firmly rooted in his practical experience of the feature and as such contained a mixture of positive and negative results. Essentially it boiled down to, this works great for some applications and not so great for others, so you’ve really got to suck it and see.
Next it was my Clonedb talk, which seemed to go pretty well.
After that it was Joze Senegacnik talking about “To Index or Not to Index, That is the Question”. Having seen Richard Foot‘s presentation at InSync11, I was pretty confident about the answers to some of the questions Joze asked the audience.
Next up it was me again, this time giving my Edition-Based Redefinition talk. Once again, this seemed to generate a good number of questions.
Then it was back to Joze for “Getting the Best from the Cost Based Optimizer”. This was a mixed bag of tips and features relating to the optimizer. These style of presentations always contain gems that either you didn’t know already, or had forgotten you know.
After a short break it was off to the evening meal. This was a more sedate affair than the previous evening. I don’t think any of us could have coped with another full-on night. After the food we moved down to the bowling alley in the hotel, where I was spectacularly rubbish.
This morning we had plans to do some sight-seeing, but everyone was so tired we’re giving it a miss and being lazy in the hotel spa.