The Hotsos Symposium this year was incredible. It seems impossible but each year is better than the last.The mix of speakers and topics were excellent. For me, it’s hard to pick a favorite, so many of the session were spot on. Larry Carpenter opened with a great talk on Data Guard in the cloud, relieving some fears of many who worried that this would be a new leaning curve. He showed that for the most part “nothing changes”.
Then Richard Foote took the stage to talk about new indexing features in 12.2, which you would expect from Mr. Oracle Index! And the most important change is now we can have identifiers up to 128 characters so you can now finally create that index named:
That you always wanted too! Of course this was in jest, it is cool to have longer names, but that isn’t really the best change. Much more useful are the new compression and the new index monitoring which finally really tells us what is going on with our indexes.
After that things moved into multisession mode and folks have to make tough decisions on which speaker to hear, would it be Roy Swonger on performance stability after and upgrade, or Tim Gorman on Data Virtualization? Or how about Mauro Pagano talking about SQL Plan directives or Stafan Koehler discussing Troubleshooting performance beyond wait events? Decisions, decisions.
Faster than I would think possible, it was Tuesday morning and Richard took center stage to talk about using AWR to help solve performance issues. Oddly he hardly mentioned indexing in this talk. He did show us how relaxing it is to be an Oracle professional in Australia, just hanging out listening to David Bowie and reading AWR reports.
Then back to multisession mode for much of the day and rounding out with Kerry Osborne talking BIG DATA. Interesting discussion on how all these pieces fit together, big data, transactional data, Oracle and Hadoop. There are a lot of moving parts going on here, it will be fascinating to see how this all works out in the coming years.
Now it was the Dinner and celebration with dancing video games, janga, foosball, air hockey and lots of geek talk of course!Wednesday morning was right into multisession mode with great sessions by Roger Cornejo showing customized database tuning tools to see beyond AWR, and Carlos talking SQL Trace TKPROF and plans for beginners. Before lunch Toon Koppelaars and Bryn Llewellyn compared the “NoPLSQL” and Thick Database paradigms. It was pretty clear that ThickDB was the winner in performance more often than not. It's YUGE!
And to finish the day we had a lively expert panel of Richard, Bryn, Kerry and Toon. Good questions from the audience on a wide range of topics.
Wow what a week, as normal we all felt a bit off balance as our brains tried to assimilate all the great knowledge from the week. If you were there you know the feeling. If you weren’t, you need to be there next year. The dates aren’t set just yet, but it’s always right around the beginning of March, be there and bring a friend!