SEO

#1 (**permalink**) 02-24-2008, 08:09 AM

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.

#2 (**permalink**) 02-24-2008, 08:09 AM

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

#3 (**permalink**) 02-24-2008, 08:09 AM

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

#4 (**permalink**) 02-24-2008, 08:09 AM

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.

512MB will be more than sufficient.

Now if you want to ask a question about the number of users, number
of simultaneous transactions, and/or transaction sizes and resource
requirements you'll get a different answer.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

#5 (**permalink**) 02-24-2008, 08:12 AM

On Wed, 13 Oct 2004 16:19:52 -0700, 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.

You need 640K of the main memory. I cannot envision anyone ever needing
more then 640K.

--
Artificial Intelligence is no match for natural stupidity.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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