Re: How much memory and CPU does the HP server need for a 4 terabytes Oracle database

Peter vu wrote:

> I am asked to provide a ball park estimate for how many CPUs and how
> much memory are needed for a 4 terabytes disk space Oracle database
> running under HP Unix server? Any helpful information is greatly
> appreciated.
>
>
> Thanks in advance.

Errrr ... Eight should do!

Actually - Your question is wrong. The disk size of the database is almost irrelevant.

You need to get an idea of the workload. Is this a warehouse or transaction system; how many users total and concurrently; what kinds of questions are being asked from the data; what are the service guarantees you need to meet; how well was the dictionary designed; what capabilities of Oracle are you able to use (generally minimizing CPU and memory), or do you have a constraint to keep this vendor independant; and so on.

If you can't answer these questions, then ask Oracle and HP to help you. (And be prepared to pay for capacity that you won't need until 2 months after production.)

OR

Get four 2-CPU Linux machines with 2GB main memory each, load them up with Oracle RAC (and make sure you have RAC compatible subsystems), and add more machines as capacity and performance demand. (Take PSOUG's RAC training first, though - http://psoug.org)

/Hans Received on Wed Oct 13 2004 - 19:00:33 CDT