It turns out that a lot of the headaches of the past few weeks at work are all due to an incredibly shitty primary key on a large warehouse table. Before I get into specifics there, I'd like to formally proclaim my allegiance to the use of surrogate keys and... [Read More]
Reverse Key Indexes
So I started reading the Oracle 10g DBA Handbook because I've deluded myself into thinking that I'll just memorize everything in there. The first chapter seemed to cover very basic stuff that even I had a grasp on, but it didn't take long for me to learn something new. 18... [Read More]
On the Oracle vs RedHat thing ...
This article is a great analysis of exactly what the recent Oracle announcement means for us customers. Basically: 0.25% savings!
tkprof fun under the sun
I've just recently opened the pandora's box that is tkprof, as soon as I get a grasp of it, I plan to write about it in this space. Actually reading that link, along with the official documentation, will give you a pretty good idea on how to use it.Now if... [Read More]
Oracle Docs Firefox Search Plugin and Extension
Recently stumbled upon Oracle's "Blogger of the Year", Eddie Awad. Today I found out about his Oracle Docs Firefox Extension, which also mentions his previous work on a search plugin for firefox.It also works with Firefox 2!