Here are the slides from my 2nd UKOUG Technology & E-Business Suite 2010 presentation - Surviving the Crisis With the Help of Oracle Database Resource Manager
As I mentioned during the presentation, If you find you have additional questions about the topic when you come back home from The UKOUG 2010 conference, this is the place to ask them! I’ll do my best to answer them
First of all, thanks to those who attended my presentation at UKOUG Conference Series Technology & E-Business Suite 2010, was nice to talk for such an interested audience.
As I promised, here is the presentation - Internals Of Concurrent Managers. The post will be updated later with more details, but if you have any additional questions you can meet me at the “Meet the Speakers” events at UKOUG2010 or just leave a comment here.
Yury recently raised a topic about nologging segments in e-Business Suite database. The discussion later evolved to on how indexes are affected by the nologging setting (is it worth putting indexes in nologging mode to reduce the redo generation). I wasn’t quite sure about the answer, so I decided to test it myself. Read on for results of 22 short testcases (I think the results turned out to be quite interesting and worth knowing).
Good news, I’m going to attend OOW2010 this year!
It was a hard work building my agenda, there’s about 1700 sessions to choose from, but thanks to Greg Rahn’s list of sessions presented by the members of OakTable network the task became a bit simpler. Reading through the list of presentation one is clear, there are two hot topics this year: Cloud computing and Exadata. I’ll be mostly attending sessions on performance tuning and internals of Oracle DB/RAC and Oracle e-Business Suite 11i/R12/Fusion technology stack related topics. Already now I know this is going to be an impressive event for me as I’ll get to see and hear many of the top recognised people in Oracle technology world.
I’ve also seen Tanel Poder is going to be there on Oracle Closed Word 2010, he admits it’s some kind of a underground secret event where talks about internals, kernel tracing, troubleshooting will go on. As that’s what’s really interesting to me, I’d like to be there too, so if anyone knows where it will take place and if no one minds me sitting in the corner enjoying my beer and asking questions about the topics being presented, please send me some details!
Just before the last month closing in a 11i system running on 10.2.0.4 database some patches were applied to solve couple of critical functional issues. All went fine until the month closing processes were started. It turned out the patches introduced a new issue - this time it was a performance issue, that had managed to escape the testing efforts. This post is about how a workaround using stored outlines had been applied until a proper fix was implemented.