performance – Page 4 – Learning is not a spectator sport

MAX_IDLE_BLOCKER_TIME to stop locking problems

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

One of the pieces of advice that I often see on the ‘net is that undo space is somehow this

In a perfect world, the optimizer would reach out from the server room, say to us: “Hey, lets grab a

Most developers tools out there have some mechanism to unload a table into a flat file, either as CSV, or

I had a request from a client a while back regarding masking of data. They had an application with sensitive