Re: Solaris Kernel Memory Parameters Recommendations?

From: Scott Canaan <srcdco_at_ritvax.rit.edu>
Date: Tue, 19 Feb 2002 12:59:00 -0800
Message-ID: <F001.00413792.20020219125900@fatcity.com>

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

--
Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: srcdco_at_ritvax.rit.edu

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 Tue Feb 19 2002 - 14:59:00 CST