| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: kernal values for HPUX 11i on (Superdom Itanium Processor)
If you have a mix of applications and users that have the authority to use
shared memory and the competing needs must be allocated by rigid control
rather than by reason, then the best setting is "barely big enough to run
Oracle well in your environment", and you may have to "tune" to reach the
proper balance.
If the server is dedicated to providing ORACLE database services, blow the lid off the ones that go up and make the minimums 1. By blow the lid off, I mean just use the largest number that works on your exact configuration. Then if something fails it will be due to the lack of a resource, rather than an artificial limit. None of the ones about which you inquired are minimums, but shmmin, I think, needs to be 1 to avoid situations that crop up from time to time where Oracle tests whether it can get shared memory by asking for a shared segment of size 1, and then does an exact check of the size returned instead of accepting a larger allocation. This happens and then gets fixed over time, and I don't know of any real harm in allowing the allocation of single byte areas. (The theoretical concern being with regard to fragmentation and garbage collection on release of shared memory segments.)
My opinion is that servers for Oracle should be dedicated to Oracle and pretty much nothing else unless the functional binding is very tight and the advantage high. If you insist on an actual perfect constant, the number is 42 (but you have to figure out the scale.)
Good luck!
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
SJHussain_at_alfransi.com.sa
Sent: Sunday, August 29, 2004 3:32 AM
To: oracle-l_at_freelists.org
Subject: kernal values for HPUX 11i on (Superdom Itanium Processor)
Gents,
We are brining HP superdom Itanium Processors. Can any one suggest us the best values, not the recommended default values, for the following:
shmmax
shmmni
shmseg
semmns
semmni
Also, pelase tell us what are the patches required for this, OS level.
Best Regards,
Syed Jaffar Hussain
OCP, DBA Consultant
Visit us on www.alfransi.com.sa
====== Banque Saudi Fransi - Privacy Notice ======
This message is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
use of this information by persons or entities other than the intended
recipient is prohibited. If you have received this in error, please
contact the sender and delete the material from your computer. Any
opinions and other information contained in this message that do not
relate to the official business of Banque Saudi Fransi shall be
understood as neither given or endorsed by it. Although precautions
have been taken to ensure no viruses are present in this email, BSF
cannot accept responsibility for any loss or damage arising from the
use of this email or attachments.
====== Banque Saudi Fransi - Privacy Notice ======
 |
 |