SUMMARY: Cofiguration of semaphores

From: Juan Carlos Botero (jcbotero@qoslabs.com)
Date: Mon Oct 23 2000 - 11:33:27 CDT


Thanks to all the people who responded. Here is a summary of what the
parapeters are in the /etc/system file and how to configure the values.

UNIX Environment Summary
Tabl e 2-1 summarizes the requirements for installing the Oracle8i Server.
If your
system fails to satisfy any listed requirement, perform the tasks listed on
page 2-3 as
necessary to set up your environment to meet these requirements.
Table 2-1 UNIX Environment Summary
Environmental Factor Requirement for Oracle8 i
UNIX Kernel Parameters:
Shared Memory SHMMAX 0.5 *(physical memory present in machine)
This setting does not affect how much shared
memory is needed or used by Oracle8i or the
operating system. It is used only to indicate the
maximum allowable size. This setting also does
not impact operating system kernel resources.
SHMMIN 1
SHMMNI 100
SHMSEG 10
Semaphores SEMMNI 100
SEMMSL Set to 10 plus the largest init sid.ora
PROCESSES parameter of an Oracle database
on the system.
The PROCESSES parameter can be found in
each init sid.ora file, located in the
ORACLE_HOME/dbs directory. The default
value of PROCESSES for the Release 8.1.5
prebuilt database is 50.
SEMMNS Set to the sum of the PROCESSES parameter for
each Oracle database except the largest one, plus
2 times the largest PROCESSES value, plus 10
times the number of Oracle databases. See
"Configure the UNIX Kernel for Oracle8i" on
page 2-4 for an example of this formula.
SEMOPM 100
SEMVMX 32767
Note: If any of the kernel parameters above are less than your current
values, continue to
use the current value. These are the requirements for Oracle8i only. If you
have other
programs which use shared memory and semaphores, you will need to adjust the
values
accordingly. Take into account that a system reboot is necessary for kernel
changes to take
affect when planning for current and future database requirements.

Juan Carlos Botero
(561)8939003
QoS Labs
Boca Raton, Florida

S
U BEFORE POSTING please READ the FAQ located at
N ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/faq
. and the list POLICY statement located at
M ftp://ftp.cs.toronto.edu/pub/jdd/sun-managers/policy
A To submit questions/summaries to this list send your email message to:
N sun-managers@sunmanagers.ececs.uc.edu
A To unsubscribe from this list please send an email message to:
G majordomo@sunmanagers.ececs.uc.edu
E and in the BODY type:
R unsubscribe sun-managers
S Or
. unsubscribe sun-managers original@subscription.address
L To view an archive of this list please visit:
I http://www.latech.edu/sunman.html
S
T



This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:14:20 CDT