Friday, September 04, 2009

Oracle 11gR2 buzz and my "Thank You" to Oracle

re-Hi all, and nice to see everyone busy downloading/tweaking the 11gR2.

Must say I havnt really kept up with all the buzz, but when I looked at the new features I tried to be a-typical: I'll not go and sing praise to all the new complexities yet. I'm sure they are fine and wont cause serious trouble. They will come my way in due course.

My 11gR2 buzz ?
I'm on the lookout for the simple stuff that may just be of benefit to a large number of DBA grunts like me. For the moment, I will have to let someone else study the new intricacies of the upgraded script (Hi Martin, Jason!)

I have to fuss-up that the most high-tech "fixes" I did in the last year was around conventional locking (TX Enqueue, just app-logic, talk to the vendor), Dynamic-SQL (politely lean on the vendor of the app) tweaking CBO (and not even subtle, just applied some Tapio[link]) and the (system-)statistics. Most of my work didnt come close to proper rocket science, any of you could have done it. The bulk of my assignments seem to involve pushing people, rather then data-blocks. And my email-cc skills have greatly improved in the last months. Sigh.

Reading the "wotsnew", I still found several gems of simple (I hope) and possibly very usefull features.

There is at least one client that will be interested in "Instance Caging". The site that can benefit from this as the Developers have 100 small, but sometimes nasty databases running on a single machine with 24 CPUs. And sometimes they have an "oops" moment and one instance affects the whole (development) system. Reading up on "instance caging", it is dependent on Resource-manager. That sort of locks me in, I now Have to use this Resource manager malarky... (Guess I'm a Lazy Luddite at heart)

The IGNORE_ROW_ON_DUPKEY_INDEX may well be an instant hit. I will not be able to resist abuse of that one! The benefits are Obvious.
But... (there are at least two buts)
This new hint will lead to a lot of lazy-programmer-style stuff. Potentially as dangerous as the "whenever others" that Tom Kyte is sometimes on about.
And, on a more Friday-philosophical level [link to MWidlake], I dont like the fact that a Hint has an impact anywere but on the optimizer.
I can not stop Oracle from developing (useful!) stuff like this, but it puts "Hints" in a whole different part of the game. Food for thought there.

So let me politely say "Thank You" to Oracle for the new, simple, and easy-to-use(?) features. There are a few more ones, I will explore them further when time permits.

First got to do some prio stuff, such as booking trips and updating the Agenda [link]. Hope to see some of you in Real Life on a conference, a SIG, or a Gig somewhere.


This is the footer...and this should be small text for disclaimers and the like. and some small stuff

Locations of visitors to this page And this text is placed next to the map. we could possibly hide some stuff here too for the benefit of the search-engines and if it is at color ffffff cam we put all sort of rubbish that we do not want readers to see. travel itinirary reservation ticket agent flight plane boarding attendant train connection rail ticket wait time booking flight boardingtime taxi ramp luggage suitcase trolley wheely laptop bagpack corpaorate wifi connection oracle. it will also be interesting to see what happens when this wrap around. or even if we put in spherus and worwood as additional word.