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 [EMAIL PROTECTED]
Schoen Volker <[EMAIL PROTECTED]> on 02/13/2001 11:36:03 AM
Message - From: Schoen Volker <[EMAIL PROTECTED]> on 02/13/2001 05:36 PM GMT
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
http://www.inplan.de
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Schoen Volker
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
