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