RE: kernal values for HPUX 11i on (Superdom Itanium Processor)
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 29 Aug 2004 11:27:41 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
SJHussain@xxxxxxxxxxxxxxx
Sent: Sunday, August 29, 2004 3:32 AM
To: oracle-l@xxxxxxxxxxxxx
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 ======
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
