Re: wanted: a REALISTIC server recommendation

We have just finished almost exactly what you are going to do. We spec'd two Linux boxes for 9i RAC database (App servers running on another two different boxes). 16GB of RAM and 4 physical CPUs each box.

Basically 16GB for us is a big waste, since our SGA is only about 4GB with 98% data cache efficiency.

During DEV/QA migration and initial testing, however, CPU usage was constantly over 90% on each box. So we went through the typical performance routine, primarily on the application side. We also got some good help from a Hotsos consultant.

Now we are in production. CPU usage is around 20% for each box.

the answer to your question is a huge "depends", primarily on how much you are willing to tune the application. One badly tuned query that needs thousands of executions in a day could make people think they need more and better hardware.

Good luck
JH Received on Tue Nov 08 2005 - 14:34:48 CST