Some time ago I wrote a note about using dbms_lock() to slow down your SQL, and followed up with an example of using this type of code to help with trouble-shooting.
June 15, 2008
June 13, 2008
Recent SQL
If you’re doing a little casual trouble-shooting, it’s always worth an occasional browse through v$sql just on the off-chance that you’ll find some sort of resource hog that could do with a little fixing.
June 10, 2008
Firefox
Here’s an interesting URL that I found by following an incoming link a little while ago.
If you run Firefox as your web browser, this “Customizegoogle” add-in allows you to “filter spammy websites from search results”. (It’s got a lot of other features, but this one seems likely to be the most useful to Oracle users).
I’ve got Firefox on my Linux RAC stack – but I may have to download it for my Windows boxes too, especially the laptop which is the machine I use for most of my writing.
Updated: And here’s a URL that should let you do the same thing with Internet Explorer, too.
June 8, 2008
Scientific Method
I’ve finally found out why I seem to disagree with Don Burleson more frequently that I do with other people on the internet.
From a recent OTN thread:
Me: “you’re supposed to design a theory to match the facts, not select the facts to match the theory.”
Burleson: “I think it’s the other way around, Jonathan, the scientific method requires that you start with a hypothesis.”
So that’s my problem – I let the facts stand in the way of a perfectly nice theory.
