Kernel Parameters for Oracle 9.2.0 (64bit) on HPUX 11i (11.11)

[trsuppt1]

Hi,

Does anyone know where I can find the recommended kernel parameters for Oracle 9.2.0 (64bit) on HPUX 11i (11.11)?

The following are recommended for HP-UX 11:

shmmax=1073741824 or 0X40000000
shmmni=100
shmseg=10
semmns=1000
semmni=100

Are these also true for 11.11?

Thanks

Giovanni

[Vijaya Kumar_3]

Hi

You can get only at:
http://metalink.oracle.com
It has a detailed report on this. But it is commercial.
Thanks
Vijay

[trsuppt1]

Thanks, but can you be more specific? I've got the existing information from metalink, but have only been able to find information relating to HPUX 11 not HPUX 11i

Regards

Giovanni

[Steven E. Protter]

Kernel
KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64

Patches
Per HP Bug (Doc ID: KBRC00003627) The default 64bit OS installation does not create a few required X library symbolic links. The following symbolic links need to be created:
cd /usr/lib
ln -s /usr/lib/libX11.3 libX11.sl
ln -s /usr/lib/libXIE.2 libXIE.sl
ln -s /usr/lib/libXext.3 libXext.sl
ln -s /usr/lib/libXhp11.3 libXhp11.sl
ln -s /usr/lib/libXi.3 libXi.sl
ln -s /usr/lib/libXm.4 libXm.sl
ln -s /usr/lib/libXp.2 libXp.sl
ln -s /usr/lib/libXt.3 libXt.sl
ln -s /usr/lib/libXtst.2 libXtst.sl

HP-UX 11.0(64 bit) Operating System Patches:
Sept 2001 Quality Pack
PHCO_23792 s/b PHCO_26960
PHCO_24148 s/b PHCO_25707 s/b PHCO_27608
PHKL_24268 s/b PHKL_27178 (has been recalled by HP may destroy logical volumes on PVGs - more info
PHKL_24729
PHKL_25475 s/b PHKL_27510
PHKL_25525 s/b PHKL_27364
PHNE_24715 s/b PHNE_26771
PHSS_23670 s/b PHSS_26138
PHSS_24301 s/b PHSS_26273 (only needed for C++ compiler and Pro*C++)
PHSS_24303 s/b PHSS_26559
PHSS_24627
PHSS_22868 (only needed for C++ compiler and Pro*C++)

HP-UX 11i (64 Bit) Operating System Patches:
Support Plus Bundle 'December 2002 SP-0212' or later
JDK 1.3.1.02
PHNE_27745 (For RAC systems)
PHNE_28568
PHKL_25506
PHSS_26560
PHSS_26946
PHSS_28849 (For ServiceGuard systems)
PHCO_28427
PHCO_24402

HP-UX 11.22 (IA64) Operating System Patches:
PHSS_27284 s/b PHSS_28977
PHSS_27285 s/b PHSS_28970
PHSS_27286 s/b PHSS_28978
PHSS_27287 s/b PHSS_29652
PHSS_27288 s/b PHSS_28971
PHSS_27289 s/b PHSS_29653
PHSS_27290 s/b PHSS_28973
PHSS_27291 s/b PHSS_28969
PHSS_27292 s/b PHSS_29654
PHSS_27293 s/b PHSS_28975
PHKL_28465

From metalink.oracle.com

Patches may be superseded, check the itrc.hp.com patch database.

Also, Do upgrade to 9.2.0.4

That patch fixes many issues.

If converting from 32 bit to 64 bit, see the doc I attach.

SEP

[Steven E. Protter]

Attaching my kmtune output from a production server.

SEP

[Cheryl Griffin]

The metalink mentions 64 bit without regards to 11.00 or 11.11, which I interpret as saying the OS does not matter, this is strictly 64 bit tuning.

http://download-west.oracle.com/docs/html/A97297_01/appb_hp.htm

Oracle9i Administrator's Reference
Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris
Part No. A97297-01

Appendix B
Tuning for Oracle9i on HP

[Edgar_8]

Hi,

On the subject of kernel parameters, we have a 9i db on hp-ux 11i k580 which is having
a performance problem. The db is a Data warehouse, does anyone know what the recommended
kernel parameters would be for a data warehouse db?

Thanks in advance!

[Karthik S S]

http://download-west.oracle.com/docs/html/A96167_01/pre.htm#sthref106

-Karthik S S

[Ravi_8]

Hi

http://docs.oracle.com/HTML_Storage/a90357/toc.htm

(this doc says oracle 9.0.1, same kernel parameters aslo work for oracle 9.2.0.2 for both hp-ux 11.0 and 11i)