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 * ---------------------------------- * Semaphores/Shared Memory for ORACLE * ---------------------------------- * shmmax = max size per shared memory segment * shmmin = min size per shared memory segment * shmmni = max num shared memory identifiers * shmseg = max num shared memory segments per process * semmns = max num semaphores system wide (=semmni*semmsl) * semmni = max num semaphore sets system wide (=semmnu) * semmsl = max num semaphores per semaphore set (=semopm) * semmnu = max num sempahore undo structures (=semmni) * semmap = max entries per semaphore map (=semmni*semmsl) * semopm = max operations per semop call (=semmsl) * semume = max undo entries per process * semvmx = max value of a semaphore (cannot be > 32767) 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 set semsys:seminfo_semume=100 set semsys:seminfo_semvmx=32767 [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 02/19/02 12:04 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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 > [EMAIL PROTECTED] > 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos 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).