Browsing through a few blogs over the weekend, I found this interesting item from Riyaj Shamsudeen about tracking down a lost ASM heartbeat and excessive CPU usage on shutdown.
The Northern California user group will be holding their Fall conference on 13th November in Pleasanton CA.
I mention it not just because I’m doing the keynote (on testing) but also because I think I’ll find it easy to fill my day with interesting presentations. , I’m particularly looking forward to hearing Dan Tow speaking on [...]
It’s quite surprising that I still see people arguing about the fastest way to “count the rows in a table”; usually with suggestions that one or other of the following queries will be faster than the rest:
select count(*) from tab;
select count(1) from tab;
select count(primary_key_column) from tab;
So here’s a simple test case that I wrote severall years [...]
A question came up on the Oracle database forum a few months ago asking:
What are the benefits and the downside of using IOTs on 16k blocks? Would you recommend it?
I think the best response to the generic question about block sizing came from Greg Rahn in another thread on the forum:
If someone has to [...]
[Back to Manual Optimisation part 2]
This little series started from a note I wrote about manual optimisation where I took advantage of a sort operation in a non-mergeable view to produce sorted data from a final nested loop join without including an “order by” that would have produced a large sort operation.
In fact, as I [...]
I’ve just been sent an email by Oracle University to tell me that Tom Kyte will be in Europe for three events over the next few months. If you can get a chance to go, it’s likely to be one of the best bits of Oracle education you could get. The dates are:
Denmark: 4th - [...]
I received an email a litle while ago with an unusual problem. It said:
“One of the jobs which used to take more than one hour to complete is now completing in less than 10 minutes. Neither the application developer nor we (the DBA’s) made *any* changes in the environment/code/database. I can’t work out why [...]
In the last five years I’ve visited more than thirty different countries and seen a lot of wonderful sights - some natural,some man-made. But Sunday was the first time I’ve walked into a hotel room and been overwhelmed by the view.
I was in Athens, staying at the Hilton, in a room facing the Acropolis - [...]
Browsing around over the weeend, I came across this blog.
I didn’t spend much time reading through the material, but at first sight I got the impression that a number of the articles might be useful to people who were starting to experiment with RAC systems and could do with some step by step guidance when [...]
Here’s a summary of a question that appeared on the Oracle Forum some time ago:
I had been seeing frequent log file switching (resulting in “checkpoint not complete” reports) at night when some export dumps have to occur simultaneously, so I increased my redo log file sizes from 5MB to 10MB.
I now have a user who [...]