See what I did there? 5 points to anyone who can name the reference. 10 points if you can name the original reference that I wasn't even thinking of. Void where prohibited.Sachin, broadcasting live from his blog Oracle Online Help, has posted a nice primer on the differences between three...
[Read More]
I'm on the clock ...
Padraig O'Sullivan has posted the latest edition of Pythian's Log Buffer, a weekly recap of Oracle blogger activity. The Pythian Group has been letting various bloggers host the Log Buffer from week-to-week. This next week (ending 6 April), I'll be hosting the Log Buffer. This also means I'll have to...
[Read More]
Appreciating Oracle's Read Consistency
One of the Oracle blogs in my feed reader linked to a post by Jeremy Schneider covering Oracle's read consistency and multiversioning. Jeremy linked to an article that Tom Kyte wrote for Oracle magazine late in 2005 about the subject. Frankly it had me dazed ... and slightly frightened.I've become...
[Read More]
Why Wait?
Yes I spent 10 minutes trying to come up with a clever "wait"-based title and that's all I could come up with. I even Googled for "wait" to find some inspiration.And now to tell you why "wait" ... the Oracle 10g wait interface!!!!!11 Feel my excitement. I just recently read...
[Read More]
How to Find Blocking Locks and Influence People
An oft-asked question of any DBA is "wtf is my query doing?" To translate this into a more civil tongue: "My DML statement seems to be taking extraordinarily long. Might you be a gentleman and obtain the reasons why?"More often than not it will be because one or more of...
[Read More]