Server Tuning on HP-UX

Appendix A

The following information is from the Oracle® Database Online Documentation.

The kernel parameter values shown in this section are recommended values only. For production

database systems, Oracle® recommends that you tune these values to optimize the performance of

the system. See your operating system documentation for more information about tuning kernel

parameters.

Verify that the kernel parameters shown in the following table are set either to the formula shown, or

to values greater than or equal to the recommended value shown.

Parameter

Recommended Formula or Value

ksi_alloc_max (nproc*8)

executable_stack 0

max_thread_proc 1024

maxdsiz 1073741824 (1 GB)

maxdsiz_64bit 2147483648 (2 GB)

maxssiz 134217728 (128 MB)

maxssiz_64bit 1073741824 (1 GB)

maxuprc ((nproc*9)/10)

msgmap (msgtql+2)

msgmni (nproc)

msgseg 32767

msgtql (nproc)

ncsize (ninode+1024)

nfile (15*nproc+2048)

nflocks (nproc)

ninode (8*nproc+2048)

nkthread (((nproc*7)/4)+16)

nproc 4096

semmni (nproc)

semmns (semmni*2)

semmnu (nproc-4)

semvmx 32767

shmmax The size of memory or 1073741824 (0X40000000), whichever is greater.

Note: To avoid performance degradation, the value should be greater than

or equal to the size of the available memory.

shmmni 4096

shmseg 512