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

Home -> Community -> Usenet -> c.d.o.server -> Re: How much memory and CPU does the HP server need for a 4 terabytes Oracle database

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Wed, 13 Oct 2004 16:49:59 -0700
Message-ID: <416DBF27.5000303@bea.com>

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.

If you do mainly "select 1 from DUAL", not much... ( ;) * 0.5 )

The need for memory is predecated on how much data you need to be in memory to make queries fast. If a day-to-day usage pattern will query some quantifiable and colocatable subset of the data, then that's about how much memory you need. If you are going to be constantly querying the whole DBMS contents, you will need as much as you can get, and it'll still be slow.

Joe Weinstein at BEA Received on Wed Oct 13 2004 - 18:49:59 CDT