Success is about Imagination

One of the main things I do to tune SQL is to encourage the optimizer to take path. I often take the most important steps to do first and...

Starting in Oracle 10.2.0.3 (ie not 10.2.0.2 and below) it’s easy to track what package and/or procedure a SQL execution came from using...

I love this video on “getting dreadful database performance” by Stephan Faroult. The video is hilarious and infomative:...

I’ve run into the wait “kksfbc child completion” a few times over the past but found very little written about it. I don’t have an...

One complaint I’ve heard of a number times is how code gets tested with one user and it runs fine and then gets put into production and...

I’ve always had a natural aversion to pie charts. Pie charts seem all the less apealing when compared to bar charts.  I’ve wondered if it...

Another problematic wait event in Oracle is “SQL*Net break/reset to client”. This wait event typically happens when there is something...

One of my pet peeves on Oracle is the inability to find out what SQL took out a lock that another user is waiting. It’s easy to find the...

I’m the “Program Manager” for DB Optimizer at Embarcadero, thus I found this article fascinating about the role of a “Program Manager”:...

A blog to compliment the information site at http://sites.google.com/site/embtdbo/