Monday, March 6, 2017

Hotsos Symposium 2017 #hotsym17


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:
this_index_will_be_used_to_get_data_from_the_bowie_table_in_scenarios_when_the_code_column_is_used_in_predicates_idx
  


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.



  Training day on Thursday was nothing short of spectacular with Toon Koppelaars and Vlado Barun talking about real world performance with the driving message for us to use the Oracle database as it’s designed to be used.  Again the concept of ThickDB was key to the discussion.  They used a real time database to show how some changed helped and some didn’t.  Very enlightening to see this changed implemented and the dramatic affect they could have.   They showed getting 10X 100X and even 1000X performance improvements.   My big take away (as likely was for many others) is that connection pools are almost always sized poorly and mostly to big, pushing waiting to the client end showed YUGE performance gains.  And of course:

 




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!