| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Solaris Kernel Memory Parameters Recommendations?
Details about semaphores & shared memory and how to calculate those values was once published in SunWorld Online, but the links I have are no longer valid. Based on the info in those docs, here's what I derived....
Suzy
forceload: sys/shmsys
forceload: sys/semsys
set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmns=4000 set semsys:seminfo_semmni=40 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmnu=40 set semsys:seminfo_semmap=4000 set semsys:seminfo_semopm=100
Jared.Still_at_radisys.com wrote:
>
> In addition to what you've already received, I would include settting
> SEMMNU (semaphore undo structures ) equal to SEMMNI.
>
> Not doing so can cause rather baffling errors at the OS level at times.
>
> Jared
>
> David Wagoner <dwagoner_at_arsenaldigital.com>
> Sent by: root_at_fatcity.com
> 02/19/02 12:04 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
> Subject: Solaris Kernel Memory Parameters Recommendations?
>
> I've read a couple of brief passages about setting the kernel memory
> parameters in UNIX that are required for an Oracle installation. The
> information found on MetaLink and in the Oracle 9i installation guide are
> brief at best and somewhat confusing for a non-UNIX-sys admin. like
> myself. Would some of you more experienced UNIX/Oracle DBAs please
> provide a plain English explanation describing your strategy in setting
> the following 7 parameters in the /etc/system file:
>
> SEMMNI
> SEMMNS
> SEMMSL
> SHMMAX
> SHMMIN
> SHMMNI
> SHMSEG
>
> To use a simple example, let's say the server has 1 GB of RAM to work
> with.
>
> Thanks in advance for sharing,
>
> david
>
> David B. Wagoner
> Database Administrator
> Arsenal Digital Solutions Worldwide, Inc.
> 8000 Regency Parkway, Suite 110
> Cary, NC 27511-8582
> Tel. (919) 466-6723
> Fax (919) 466-6783
> Mobile (919) 225-4962
> dwagoner_at_arsenaldigital.com
> http://www.arsenaldigital.com/
>
> *** NOTICE ***
> This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged, work
> product or exempt from disclosure under applicable law. If you have
> received this message in error, or are not the named recipient(s), please
> immediately notify the sender by phone or email and delete this e-mail
> message from your computer. Thank you.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: lvordos_at_qwest.com 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 Wed Feb 20 2002 - 14:53:26 CST
 |
 |