12-09-2002
kernel parameter settings
Hello All,
can someone clarify finally what are the kernel parameter settings
for ORACLE9i on SOLARIS9 ?
the following first part is copy paste from the sun's web rquirements
page for the installation
Kernel Parameter
Setting
Purpose
SEMMNI
100
Defines the maximum number of semaphore sets in the entire system.
SEMMNS
1024
Defines the maximum semaphores on the system. This setting is a
minimum recommended value, for initial installation only.
The SEMMNS parameter should be set to the sum of the
PROCESSES parameter for each Oracle database, adding the largest
one twice, and then adding an additional 10 for each database.
SEMMSL
256
Defines the minimum recommended value, for initial installation
only.
SHMMAX
4294967295
Defines the maximum allowable size of one shared memory segment.
4 GB = 4294967295
SHMMIN
1
Defines the minimum allowable size of a single shared memory
segment.
SHMMNI
100
Defines the maximum number of shared memory segments in the
entire system.
SHMSEG
10
Defines the maximum number of shared memory segments one
process can attac
AND THE FOLLOWING PART IS copy paste of another INSTALLATION GUIDE FOR ORACLE
VERSION 9.2..0.1.0
This is what they say:
Add or modify the following parameters, using any higher val
ues if they
already exist on your system. These settings can be placed at the end of the file.
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
Please i will appreciate your time and help if you
can explain what are the right setings and format.
thanks,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
How to change the system parameter (kernel Parameter)
in sun solaris..i wan't to increase the maximum no of user processs.i found it frm sysdef command that it has a value of 3048
i wan't to increase it as smtime while forking a new proceess it,s giving error max limit of user process... (1 Reply)
Discussion started by: Prafulla
1 Replies
2. UNIX for Dummies Questions & Answers
Would someone please help explain what the following kernel settings indicate on HP 11.00. Thanks Kristian.
Parameter Value
maxuprc 10156
nfile 65430
semmni 45185
semmnu 20236
semmns 45315
shmmni 18264 (1 Reply)
Discussion started by: kristian
1 Replies
3. UNIX for Dummies Questions & Answers
Hi all
I am using HPUX 11.00 .its a HP9000 L class server with 1gb ram and dual processor 540Mhz.
i want to know abt the two kernel parameter mentioned below
1)maxdsize
2)maxssize
these two parameter has the default values and it has not been changed once.
as some application on this... (1 Reply)
Discussion started by: Prafulla
1 Replies
4. UNIX for Dummies Questions & Answers
Hello and thank you everyone that has helped guide me in the past.
I need to change the max_thread_proc parameter in order for certain Oracle utilities to function correctly. It is currently set at 64.
I am a dba not an sa so please excuse my lack of knowledge on something that is probably... (7 Replies)
Discussion started by: soestx
7 Replies
5. UNIX for Dummies Questions & Answers
Hello everbody:
I have Sol9, and I need to check its kernekl parameters, do you know how to list them or in which file they can be found.
Thanks in Advance (3 Replies)
Discussion started by: aladdin
3 Replies
6. HP-UX
Hi,
May I pls. know what would be the equivalent kernel parameter in HP-UX for the below Linux kernel parameter.
sysctl kern.ps_showallprocs - This setting in Linux would let users see their own processes in "ps".
Thanks,
Narasimha (1 Reply)
Discussion started by: vnarsim
1 Replies
7. UNIX for Dummies Questions & Answers
Hi All
Need to find kernel parameter values of our UNIX box.
/filesys1/tmp>uname -a
HP-UX hps1_dc B.11.11 U 9000/800 1681349356 unlimited-user license
/filesys1/CDBLprodrun/tmp>
Can anyone help me with the cmd to find kernel parameter values?
Thanks in advance. (1 Reply)
Discussion started by: mhbd
1 Replies
8. HP-UX
Hi.
I wanted to know, that if an issue is coming, where ,on running a load test, the memory of the APP server(unix) increases, but does not come down once the test is over, in that case, does tuning the nk thread paramter help in teleasing of the memory..???
plz answer soon (2 Replies)
Discussion started by: TC123
2 Replies
9. UNIX for Advanced & Expert Users
Hi all,
I have four (4) different UNIX flavours and I want to know whether the following commands are correct with respect to wanting to check on what are my current kernel parameter settings.
I just want to clear the doubts hanging over my head whether the commands below are the right ones... (2 Replies)
Discussion started by: newbie_01
2 Replies
10. UNIX for Advanced & Expert Users
I have solaris 9 system.
I want to change the "tcp_conn_req_max_q" setting in /etc/system.
whats the correct way,
set ndd:tcp_conn_req_max_q=2048
or
set tcp:tcp_conn_req_max_q=2048
thanks (1 Reply)
Discussion started by: chaandana
1 Replies
settune(2) System Calls Manual settune(2)
NAME
settune() - set the value of a kernel tunable parameter
SYNOPSIS
DESCRIPTION
This function sets the value of the kernel tunable parameter named tunable to the supplied value. This new value takes effect immediately,
except in the cases noted below.
Some parameters cannot be changed without rebooting the kernel. These parameters cannot be changed using
Some parameters represent limits on resources that can be consumed by individual processes. In general, changes to these parameters do not
affect processes that are running at the time the change is made; they affect only new programs started (with or an equivalent) after that
time. Some specific parameters may be exceptions to this general rule; see the man pages for those parameters for details.
Valid values for the flags parameter and their connotations are:
The value of the tunable parameter is set by the kernel. The
value parameter to is ignored.
Sets the tunable parameter to the
value and turns off any automatic tuning done by the kernel.
The call can give information about whether or not changes to a parameter are allowed or will require a reboot. Some individual parameters
may have specific notes regarding their behavior when changed; consult the parameter man pages for details on each specific parameter.
Security Restrictions
The actions associated with this system call require the privilege. Processes owned by the superuser have this privilege. Processes owned
by other users may have this privilege, depending on system configuration. See privileges(5) for more information about privileged access
on systems that support fine-grained privileges.
RETURN VALUE
This function returns one of the following values:
The value of the specified parameter has been changed.
The function did not complete successfully. The value of the specified
parameter has not been changed.
ERRORS
If this function returns to indicate an error, the global variable will be set to one of the following values to indicate the error that
occurred:
The specified tunable parameter does not exist.
tunable specifies an address that is inaccessible.
The caller does not have the
privilege.
The specified value is not within the acceptable range for the specified
parameter.
The value of the parameter could not be changed immediately.
The specified parameter cannot be changed without rebooting the kernel.
The Kernel Registry Service was unavailable or encountered an error.
Insufficient memory to accommodate the new parameter value.
WARNINGS
It is possible to seriously degrade system performance, or even render a system unbootable, with incorrect tunable settings. Use care when
setting tunable values. Always have a known working kernel configuration saved as a backup; if the system fails to boot after a tunable
change, boot from that backup kernel configuration. Keep good records of all tunable changes so that they can be reversed if they degrade
system performance. Tunable changes made with are automatically logged to
If the tunable being changed through is used in expressions that set the values of other tunables, those expressions will not be re-evalu-
ated and those tunable values will not be updated. Note that this behavior may change in future releases of HP-UX. If expression evalua-
tion is desired, use to set tunable values.
Changes to parameter values made with may not remain effective across reboots. Note that this behavior may change in future releases of
HP-UX. If persistence across reboots is desired, use to set tunable values.
AUTHOR
was developed by Hewlett-Packard Company.
SEE ALSO
kctune(1M), mk_kernel(1M), gettune(2), tuneinfo2(2), privileges(5), and the individual tunable parameter man pages in section 5.
settune(2)