Well, another Oracle Open World has bit the dust, and as is always the case, there was a lot of great material presented, both by Oracle employees and customers. To help you identify the material and get your hands on the presentations where possible, I’ve taken a stab at grouping all the material together into sections. These are the areas the presenters identified the material as covering, so if the title doesn’t seem to match that area blame the presenters.
After a recent upgrade to 184.108.40.206, I’ve been working on a number of performance issues. Many such issues are related to poor SQL and a number of issues I’ve resolved I’ve proven were issues in the old 220.127.116.11 release. This just means it’s always been an issue. But people are taking the opportunity of the upgrade to get me to fix things that have been broken for quite a while.
I’m leaving Open World 2015 a day early. I managed to pack in an awful lot of activity into the three days I was here and I met up with some very nice people. I expect that my OOW experience was similar to many others. There was so much to do and not enough time. But I’m happy to be going home as well.
After our recent upgrades to Oracle 18.104.22.168, we noticed a few non-production databases that were filling up the DIAGNOSTIC_DEST. There were huge trace files in there which contained this type of information:
----- Cursor Obsoletion Dump sql_id=6aca4drrt76x3 -----
Parent cursor obsoleted 1 time(s).
It appears this is a known bug in 22.214.171.124. Oracle turned on some diagnostic info and forgot to turn it off. But you can turn it off in your environments with the following:
alter system set "_kks_obsolete_dump_threshold" = 0;
New Cloud Services Enable Organizations to Gain an End-to-End View of Applications From End-Users to the Underlying Infrastructure, Effectively Manage Diverse IT Environments and Drive DevOps Efforts…. Read what Finance Yahoo tell us about it
I’ve been working with MongoDB a bit and one of the things I like about it is how sharding helps the platform achieve high performance. MongoDB is not the only database platform that uses sharding, just one of the more mainstream ones. While I’ve been working with MongoDB and admiring sharding and the ability to handle JSON documents, I’ve also been troubled by a few other things.
I attended a session today at Oracle Open World 2015 by Markus Michalewicz which highlighted some new features we can look forward to for Oracle Grid Infrastructure 12.2, currently in beta. There were lots of new features, but a few stood out as major changes to the architecture.