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]
Saving Daylight for Oracle EM dbconsole
The big DST scare came and went and I thought I had gotten off scott-free. I ran Oracle's utility to determine if I had any timezone-sensitive data, and it reported that other than the GATHER_STATS_JOB, I don't. I didn't mind letting the stats gathering shift for an hour until I...
[Read More]