kernel parameters change

[thijs lankhorst_1]

Hi we are planning an upgrade of Oracle from 8.0.6 to 9 and one of the pre-requisites is that i change certain kernel parameters. This obviously is no problem however i want to know if the following changes will impact on the performance of the servers i want to make the change on? So does anybody has experience with the above and can enlighten me?

Increase the kernel parameter KSI_ALLOC_MAX to 32768 from present setting of 24000
Increase the kernel parameter MAX_THREAD_PROC to 256 from present setting of 64
Increase the kernel parameter MAXSWAPCHUNKS to at least 16384 from present setting of 4096
Increase the kernel parameter MAXUPRC to at least 3687 from present setting of 2700
Increase the kernel parameter MSGMNI to at least 4096 from present setting of 3000
Increase the kernel parameter NCSIZE to at least 35840 from present setting of 31168
Increase the kernel parameter NFILE to at least 63488 from present setting of 47048
Increase the kernel parameter NINODE to at least 34816 from present setting of 26048
Increase the kernel parameter NKTHREAD to at least 7184 from present setting of 5266
Increase the kernel parameter NPROC to at least 4096 from present setting of 3000
Increase the kernel parameter SEMMNU to at least 4092 from present setting of 1000
Increase the kernel parameter SEMVMX to at least 32768 from present setting of 32767
Increase the kernel parameter VPS_CEILING to at least 64 from present setting of 16
MAXDSIZ set at 268435456 needs to be increased to at least 1073741824
MAXSSIZ set at 16777216 needs to be increased to at least 134217728
MAXSSIZ_64BIT set at 16777216 needs to be increased to at least 1073741824

Thanks for your help.

[Devender Khatana]

Hi,

The changes are required for oracle upgradations but I am not sure if you wish to increase the parameters now itself when oracle 8.0.6 is still running is yes this is not recommended. Upgrade these only when you upgrade oracle.

Needless to write that the values will depend upon various other parameters like no. of users and system config/application which you allready should have been considered.

HTH,
Devender

[Lee Harris_5]

Thats what I was gonna say :-D

[thijs lankhorst_1]

Cheers Devender...thanks lee :-). I considered the apps side but the difficulty is that we have about 200 servers with various amounts of users and load (as you know lee) but the settings have to be the same on all servers. So in your expert opinions would you go thru every single server individually and assess the risks involved or looking at the new values would you be happy to extend it after testing it on a couple of servers (with various loads)?

[Devender Khatana]

Hi,

It would also depend upon current parameters, if these are working fine then I would suggest to test on a few servers of different types and then apply it to all. Also save current parameters to a file on all servers for some further refrences later on.

But some paraters are dependant upon memory as well does all server have same memory/cpu etc?

HTH,
Devender

[thijs lankhorst_1]

Devender...most servers have the same mem but there are differences in cpu. But i probably can devide them in 4 groups. I think i will just test it on the couple of dev servers and depending on this i will roll it out.

Thanks for your help