Kernell Parameters in HP-UX Install.

[Victor Burguillos_4]

Hi,
I need the kernell parameters that is necesary change before install oracle and my SQL.

Thanks a lot.

Regards,

VB

[Tim Nelson]

The best info is in the Oracle and MYSQL install guide.

Some depend on the system size and the expected workload which you have supplied no information to work with.

[Michael Steele_2]

Hi Victor:

I agree with Tim, call oracle. This is one of those situations where several oracle products are involved and their might be variations. Besides, Oracle will have a script for you to run that checks for these things and also patches, etc.

Anyway, here's an example of what to expect, but do your homework and call Oracle. Its very painless.

KSI_ALLOC_MAX set to 65696 is adequate
MAX_THREAD_PROC set to 512 is adequate
MAXSWAPCHUNKS set to 16384 is adequate
MAXUPRC set to 8207 is adequate
MSGMAP set to 30642 is adequate
MSGMNI set to 57484 is adequate
MSGSEG set to 32767 is adequate
MSGTQL set to 82120 is adequate
NCALLOUT set to 8212 is adequate
ALERT- Increase the kernel parameter NCSIZE to at least 35840 from present setting of 22084
NFILE set to 65184 is adequate
NFLOCKS set to 16424 is adequate
ALERT- Increase the kernel parameter NINODE to at least 34816 from present setting of 16964
NKTHREAD set to 30000 is adequate
NPROC set to 8212 is adequate
SEMMAP set to 15322 is adequate
SEMMNI set to 15320 is adequate
SEMMNS set to 30000 is adequate
SEMMNU set to 8208 is adequate
SEMVMX set to 64000 is adequate
SHMMAX set to 1073741824 is adequate
SHMMNI set to 1024 is adequate
SHMSEG set to 512 is adequate
VPS_CEILING set to 1024 is adequate
ALERT- MAXDSIZ set at 2684354560 needs to be increased to at least 1073741824
MAXDSIZ_64BIT set to 3489660928 is adequate
MAXSSIZ set to 391118848 is adequate
MAXSSIZ_64BIT set to 1073741824 is adequate