Re: Speed executing

Assuming you have properly tuned the query, applied the correct indexing strategy, maintained the disks and eliminated all other possible bottlenecks, you might see a performance improvement of between 0 and 5.9 sec. by going to a 2 CPU system.

However, you might also see a performance improvement of 0 and 5.9 sec simply by tuning the query, applying the correct indexing strategy, eliminating all other possible bottlenecks without changing your machine to dual CPU.

There are literally dozens of ways to improve your performance. Many are described in the Performance Tuning documentation, white papers, and so on, that are freely available (for example at http://otn.oracle.com) Unfortunately upgrading hardware without having tuned first is a sign of the times - "throw money at the problem, maybe it'll go away."

IMHO, the addition of memory will help, in any case. I find that 256M is generally light for any Oracle based system. However, "memory in the machine" may not be as effective as "memory in the machine that is available for Oracle's use".

/Hans
It is far easier to throw hardware at a problem than to understand the problem and think about a solution. - HF Received on Mon Mar 24 2003 - 10:37:51 CST