performance – Learning is not a spectator sport

Datatype conversions – strange internal function

Perhaps the most famous (or infamous) performance tuning problem you’ll find spanning decades of blog posts when it comes to

In a world where databases are now the norm, whereas distributing data via a CSV file used to be commonplace,

The other day as my PC popped up its usual “Hey, you really should look at buying a bigger disk”

We’ve all been there … You’re trying to save some changes to the database, and no matter what you try,

There has always been a bit of a Catch-22 with some of the really cool options in the Oracle Database.

Need to get a bunch from rows out of the database? Most people are aware of the ARRAYSIZE parameter to

Man, it gets my goat when people start pontificating nonsense on Twitter. Yeah, I know, I know, I shouldn’t get

We had a question on AskTOM inquiring about how to handle the issue of only 8 storage indexes being possible

I did a set of articles for Oracle Magazine on a more holistic view of SQL tuning. What do I