SUMMARY: adding additional memory

From: Mark_Conroy@em.fcnbd.com
Date: Mon Apr 13 1998 - 17:00:50 CDT


     My thanks to:
     
     Ian TCollins
     Andrew Ho
     
     
     
     Ian responded with the how to verify RAM+DISK with:
     
     
     Demand paging (de in vmstat) is the one to check.
     
     I assume Oracle likes to have as much RAM as the database size, so
     this would give some idea.
     
     A swap -s will show how much memory (RAM+disk swap) is in use, this
     should also show how much more is required (if total used > RAM).
     
> My question is that I want to add additional memory, but does
     someone > have a "rule of thumb" on how much memory to add. I
     realize I will
> need additional disk space to add the swap, but that shouldn't
     be an > issue.
>
     You will _NOT_ need additional disk space to add the swap! Solaris
     uses RAM+disk
     is its swap, so the reverse is true, the more RAM you have, the
     smaller the disk swap has to be (you're thinking of SunOS).
     
     
     
     Andrew responded with Oracle utilization as:
     
     Well, oracle 8 initially runs ora_dbwr_, ora_reco_, ora_ckpt,
     ora_smon, ora_lgwr, per instance of the database. Each of these
     ususally taks 33mb, around 11mb or so runs in resident memory....
     so figure you need at least 60mb of real memory per instance of
     oracle, and that is not counting other overhead. You also need to
     know how many users are making transactions and the number of
     transactions over a period of time. I'm suprise that your machine
     is even keeping up with 128m of memory with 3/4 instance. Oracle
     8 comes with a pretty good doc on figuring out how much resource
     you need. Sorry for such a short reply, but the docs will really
     help you.
     
     
     My thanks to both of you for your time and help.
     
     Mark Conroy
     
     
     
     
______________________________ Reply Separator _________________________________
Subject: adding additional memory
Author: Mark_Conroy@em.fcnbd.com at Internet
Date: 4/10/98 7:54 AM
     
     
     Question for the group,
     
     I have a sparc 1000e running Soalris 2.6 with 128m memory. It is a
     developmental machine and they are running Oracle 8.0.4. They have
     increased the number of oracle instances running on this machine. I
     have installed some scripts to gather system statistics daily, and I
     have noticed that the machine is doing a lot of paging, and I am sure
     this is the result of the additional instances(running 4 instances).
     
     My question is that I want to add additional memory, but does someone
     have a "rule of thumb" on how much memory to add. I realize I will
     need additional disk space to add the swap, but that shouldn't be an
     issue.
     
     Any thoughts would be appreciated.
     
     Thanks
     
     Mark Conroy



This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:12:36 CDT