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 * -- * 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).
Re: Solaris Kernel Memory Parameters Recommendations?
Hello David, I hope you have received some replies on this.. can you please forward it to me.. I lost the email in reply to this while reading Thanks in Advance. Nikunj Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: David Wagoner To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 12:04 PM Subject: Solaris Kernel Memory Parameters Recommendations? Ive 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, lets 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.
Re: Solaris Kernel Memory Parameters Recommendations?
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).
Re: Solaris Kernel Memory Parameters Recommendations?
This is what I use: SHMMAX = ½ of physical memory SHMMIN = 1 SHMMNI = 100 SHMSEG = 10 SEMMNI = 100 SEMMSL = 10 + SUM(initsid.ora PROCESSES parameters) SEMMNS = SUM(initsid.ora PROCESSES parameters) + largest initsid.ora PROCESSES parameter + (10 * number of instances) SEMOPM = 100 SEMVMX = 32767 I got the formulas for SEMMSL and SEMMNS from Oracle, via a tar. They aren't the same as the ones in the manual. Also remember to add in semaphore numbers for other applications that may be running on the machine (like Patrol). David Wagoner wrote: Ive 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, lets 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. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer