Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

kmtune..

imran hussain_1
Occasional Contributor

kmtune..

All,

I have got a HPUX:v11.11 box which currently has 54 database's a mixture of 8i and 9i(mostly 9i).. I have recently created more database's on the box, BUT I have no idea what I should increase the kernel parameter's by.

This is what they are currently set to :


shmmax 1073741824 Y 1073741824
shmseg 200 Y 200
shmmni 1024 - 1024
semmni 1024 - 1024
semmsl 2048 Y 2048
semmns 9800 - 9800
semmnu 30 - 30
semume 10 - 10
semmap 1026 - (SEMMNI+2)

Any help would be much appreciated !

Thanks.

Ps I have attached the kmtune output..
2 REPLIES
Steven E. Protter
Exalted Contributor

Re: kmtune..

The answer almost always is, it depends.

What you need to do is determine your actual use of shared memory for example and files and such.

Best tool for that is glance graphical tool gpm.

It has a nice display for showing how much you are using on system parameters and swap and another report on shared memory.

Each adjustment is important and different.

You may want to increase total shared memory shmmax. But if you increase it beyond 25% of memory, which HP-UX defines as ram plus swap, the setting will be ignored.

In spite of this situation Oracle 10G app server requires shmmax to be 100% of Ram, ignoring the OS, which may explains why it runs as it does in our shop.

Oracle has some tools at metalink.oracle.com that let you analyze a hpux system and recommend changes, even during actual use. Its a good tool, but don't let it replace your brain. On more than one occiasion oracle' people or tools have advised me to do things that can only be described as the opposite of brilliant.

Good Luck,

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com

Re: kmtune..

Imran,

Kernel configuration settings are documented in note 169706.1
" Oracle RDBMS on AIX,HP-UX,Solaris,Tru64,Linux,MacOSX: Versions, Sizes, Requirements Quick Reference"
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=169706.1

which is fairly convenient and updated from time to time.
Otherwise, or if you do not have access to Metalink you'll have to consult the IG and RN (on CD or otn.oracle.com). Check as well the UNIX Administrator Reference Appendix B Tuning for Oracle9i on HP
http://download-west.oracle.com/docs/html/A97297_01/appb_hp.htm#i637463

On the kernel parameters you'll might want to check with the HP-UX Performance Cookbook of interest as well:
http://www.interex.org/pubcontent/enterprise/nov01/grumann.jsp

The Oracle recommended kernel parameter setting for ninode presumes you're using HFS for example; it does not apply when using VxFS.

It all depends ...

Regards,
Denys van Kempen