The Symposium was fabulous as always. Saw many friends and made some new ones. Also received an email from a former coworker who learned of my presentation via Alex G's blog. It's amazing how this blogging world works ...
1. I had to leave Tapio Lahdenmaki's presentation on indexes right after it started due to an important issue at home. I was quite disappointed as it was one of the presentations I had most looked forward to, but fortunately, he provided excellent notes along with his slides.
2. Riyaj Shamsudeem did a very information-packed presentation on a new way to use a 10053 trace. This one may need to be a 2 hour time slot next time, but I like presentations that leave me wanting more.
3. Andy Zitelli's topic on leveraging the extended SQL trace was an eye opener too. I'm going to have to try out his scripts and see if this approach could be applied to our benchmarking and load testing efforts.
4. Dominic Demolino's presentation on using auditing for Change Management and upgrade scripting was another one that got me thinking about an old problem from a new angle. I look forward to experimenting with these scripts too. I had wanted to talk to Dominic about his recent blogs on old parameters in upgraded databases but didn't get the chance. His posts made a very good point and I agree with him: init.ora parameters should be reconsidered at every upgrade. Similarly, sites that use ip node checking in their sqlnet.ora files need to take the time to clean up the old addresses. It does little good to limit connections by ip address if the included address list is never purged.
I actually wrote the notes above in the week after Hotsos, however due to a now resolved family crisis, it's been sitting in 'draft' status ever since. So the info is delayed but will still serve as a reminder for things to follow up on.
As for what I've been up to since Hotsos, here's the short list:
I have set up our first real Oracle 11g install to be used for real development. Thus far, I'm unexpectedly pleased with it considering it's still on the new side. There will be more on this to come.
Have also had the opportunity to benchmark an Oracle competitor for large databases. It's strange to be on a new technology and one without instrumentation at that, but the product looks sufficiently interesting for further tests. There should be more on this later as well.
Continuing to look for ways to add instrumentation to our applications. Lots of thoughts on this, but more research is needed.
Think this post shall be filed under 'to do list' :)