kmtune..

[imran hussain_1]

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..

[Steven E. Protter]

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

[Denys van Kempen]

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