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]
Tags: wait oracle

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]
Tags: locks oracle

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]

40 Tips from Tom Kyte

Robert Vollman, via his oracleblog, offers a great list of 40 Tips from Tom, collected from just the articles updated this past week on AskTom. Definitely worth reading as well as following the links to the actual AskTom articles.P.S. -- Just in case you didn't know, "Tom" is Tom Kyte.... [Read More]
Tags: tkyte oracle