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]
ojdbc vs. gcj
If, upon your travels, you should encounter this error:java.lang.ClassNotFoundException: oracle.security.pki.OracleWalletyou probably want to double-check your java executable:# java -versionjava version "1.4.2"gcj (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3)Copyright (C) 2006 Free Software Foundation, Inc.This is free software; see the source for copying conditions. There is NOwarranty; not even for MERCHANTABILITY or...
[Read More]