Re: Memory Required for Alpha Server & Oracle database
Date: 1996/03/15
Message-ID: <4ib2ap$i1q_at_dfw-ixnews4.ix.netcom.com>#1/1
Wong Yeow Kiat <spccrd_at_pacific.net.sg> wrote:
>Hi,
>I hope somebody out there can help, thanks in advance.
>I am in the process of getting a Alpha Server 2000 4/233 with 128Mb memory. This
>server will be running only Oracle RDBS, most probably version 7.2. My question
>here is how much memory required for Digital Unix OS (v 3.2 or 3.3) to run and how
>much left over for Oracle RDBS to run in optimal performance (only maximum 5 users
>will be running simultaneously). Is 128Mb memory sufficient???
>regards,
>Yeow Kiat (S'pore Petroleum Co Ltd)
Yeow,
It depends on how big your database is what kind of DB (Decision
support or transaction based) and for what other purpose your UNIX box
is used. Alot depends on what your doing with all those CPU's. If
your crunching numbers in another application and your 5 database
users are putting only a light load on a small DB then you may be ok.
For my taste a DEC 2100 4/233 with 128MB RAM seems a little lean for that kind of horse power, I'd think at least 256MB RAM just to give each of those CPU's some elbow room.
I have several DEC's from 1000s to 8400s all database machines with a minimum of 512MB RAM each (the 8200's and 8400's with 2GB) and typically 4 or more processors each. I'm primarily decision support with database sizes ranging from a few GB to the TB range and user loads from 5 people up to the low thousands. I try to cache as much as I can for performance on my DSS systems so they typically use more memory. The OLTP systems can get away with less memory.
Databases like performing their own memory management so you should set your shared memory (shmmax) on the DEC as high as possible without having the machine page or swap (see vmstat). Take care to consider the impact on any user processes which may also reside on the same machine as well as the memory required by the OS.
Regards! Received on Fri Mar 15 1996 - 00:00:00 CET