performance – Learning is not a spectator sport

Exadata storage indexes

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

I’m sure most of us have read or heard at a conference the benefits of array fetching and array binding