Re: Solaris Kernel Memory Parameters Recommendations?

[Scott Canaan]

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: 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. -- 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