Author Archives

Juggernaut

One of the problems of “knowing” so much about Oracle is that the more you know the more you have to check on each new release of the software. An incoming ping on my posting “Lock Horror” reminded me that I was writing about 11.2.0.1, and the terminal release is 11.2.0.4, and the whole thing may have […]

Juggernaut

One of the problems of “knowing” so much about Oracle is that the more you know the more you have to check on each new release of the software. An incoming ping on my posting “Lock Horror” reminded me that I was writing about 11.2.0.1, and the terminal release is 11.2.0.4, and the whole thing may have […]

Diagnostics

Here’s a little test you might want to try. Examine the following script, and decide what sort of symptoms you would see in the AWR report. I don’t need anyone to tell me their results – but if your predictions and the actual results match then you can give yourself a pat on the head. […]

Diagnostics

Here’s a little test you might want to try. Examine the following script, and decide what sort of symptoms you would see in the AWR report. I don’t need anyone to tell me their results – but if your predictions and the actual results match then you can give yourself a pat on the head. […]

Min/Max

One of my most-repeated observations about trouble-shooting Oracle is that things break when you start combining features. Here’s an example that demonstrates the point. It’s possible to create “descending” indexes – or indexes with descending columns, as I prefer to call them, and there’s a special “min/max range scan” optimizer operation for a particular kind […]

Min/Max

One of my most-repeated observations about trouble-shooting Oracle is that things break when you start combining features. Here’s an example that demonstrates the point. It’s possible to create “descending” indexes – or indexes with descending columns, as I prefer to call them, and there’s a special “min/max range scan” optimizer operation for a particular kind […]