I attended, (and presented) at RMOUG this year and although it wasn’t as much of a “class reunion” as I expect, (seeing everyone that I’ve worked with at previous companies) I still did meet up with some previous coworkers and met some really great new DBA’s and Developers. It may just have been me, but I decided with the recession, attendance was down and I just need to help and promote it more along with everyone else! 🙂 My presentation was on parallel execution and no one seemed to notice it was my first presentation- which is a good sign.…
-
-
Tanel Poder had a great post about bind variable peeking, http://blog.tanelpoder.com/2010/02/02/bind-variable-peeking-execution-plan-inefficiency/ I run into this exact issue more often than I would like to and have found a few tricks to refrain it from happening in code that is “vulnerable” to the situation. Truthfully, there isn’t much you can do when Oracle has gone in and performed a bind peek and chosen a poor example to peek on. As a DBA, you simply know there is an issue when the explain plan states that the CBO has determined the cost is exceptionally low to perform a nested loop on a…
-
The Lead Developer and I have been working very, very hard on tuning the main process that produces much of the revenue for our company. The tuning exercise has been very successful but we’ve run into some challenging on the pre-processing that occurs for each week to build the mart that the newly tuned process runs on afterwards. Due to this, I’ve been granted some time to monitor the build process a little closer than previously and although I have a lot of tuning to do, some of the largest challenges comes in the form of queries that the analysts…