Re: Oracle - solving performance problem

Throwing dollars at hardware to solve the problem should be the last thing you do, not the first. What if you invest in a big dollar server and performance is still far short of your goal? There might well be much less costly and far more effective solutions.

That one client query that you mentioned that is taking too much time - figure out specifically what it is doing during those 2 minutes. The available statistics tools (and consultants) can often show a path to utilizing available resources far more efficiently. You can always run out and buy a megaserver later.

My 2 cents worth Received on Fri Oct 07 2005 - 17:37:00 CDT