Re: Unix Memory Question

From: <exu_at_nnng.com>
Date: Tue, 13 Feb 2001 11:32:39 -0800
Message-ID: <F001.002B2DDA.20010213111041@fatcity.com>

I believe that there are no easy answer to you how much memory that you can add to your SGA. You need to some experimental work to find out how many memory that you can take away from system without dragging it down(or over burden it). You can use 'vmstat' and 'sar -w' to monitor memory swapping. The rule of thrumb is that you should see no memory swapping out in your system.

Eveleen

Please respond to ORACLE-L_at_fatcity.com

Schoen Volker <v.schoen_at_inplan.de> on 02/13/2001 11:36:03 AM                                                                                 

  Message - From: Schoen Volker <v.schoen_at_inplan.de> on 02/13/2001 05:36 PM GMT                                                                                 

                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <ORACLE-L_at_fatcity.com>                              
                                                              
 cc:      (bcc: Eveleen Xu/NNIB/NNNG)                         
                                                              
                                                              
                                                              
 Subject: Unix Memory Question                                
                                                              

Hi list,

I have a question about Unix and Oracle memory allocation. I have to say that Unix isn't my platform, so I think for most of you this will be easy answerd.

I have a HP Unix machine with follwing memory infos:

Memory Information:

    physical page size = 4096 bytes, logical page size = 4096 bytes     Physical: 524288 Kbytes, lockable: 380640 Kbytes, available: 441536 Kbytes

There is a Oracle running on this box. Hit statistics show me that I have to increase the db_block_buffers. What I like to know is, how much more memory can I give oracle? There are about 50 User working with this instance.

TIA Volker Sch

ön
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Schoen Volker
  INET: v.schoen_at_inplan.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 13 2001 - 13:32:39 CST