Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SGA, Oracle and RAM

SGA, Oracle and RAM

From: dbuckingham <member8912_at_dbforums.com>
Date: Tue, 20 May 2003 06:53:59 +0000
Message-ID: <2900033.1053413639@dbforums.com>

I am interested to know how Oracle uses the physical memory on a machine.

When you size the parameters in the INIT.ORA file you determine the size of the SGA, but how much of this SGA is loaded into physical memory and how much is used by Virtual memory? (or is it more of a case, if the RAM is available, then it will grab it?)

However, is this all of the RAM then that the instance needs? or will processes spawned by the Instance result in the Oracle DBMS using additional RAM as well (additional to that which it will grab upon booting the server)?

I am asking this for I am about to build an Oracle server that will have multiple instances on it. But I am not sure exactly how big to make the SGA's do I create them to utilise the max amount of ram possible, or make them smaller so that there is a fair bit of ram left vacant on the machine?

Can someone point me in the right direction, I have tried looking at various documentation out there, but it basically talks about sizing the various parameters to create the SGA. I have not found anything discussing my other thoughts.

--
Posted via http://dbforums.com
Received on Tue May 20 2003 - 01:53:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US