How to Apply General OLTP/Database Kernel Parameter Set?

[Olga_1]

I am trying to Apply General OLTP/Database Kernel Parameter Set through SAM. Any idea how to do it? I cannot find it in Kernel Configuration menu.

Thank you.

[Berd]

Olga,

Do you know the specific kernel paramters you are looking to change ?

Berd

[Olga_1]

No, I was asked to apply set of General OLTP/Database Kernel Parameter. It is a new server.

Thank you

[Berd]

Olga,

I think you need to ask the question, 'What specific kernel paramters are required to change', and what values to apply.

Oracle and SAP for example provide a kernel parameter list together with recommended values.

Regards,
Berd

[Olga_1]

Berd,
But there is should be a parameter set, like in old version: "Apply tuned parameter set"

[Berd]

Olga,

what type of server are you trying to do this on ?

[Olga_1]

Itanium HP11i v2

[OldSchool]

Olga,

Does the following work for you?

"kernel config" -> "configurable parameters" -> "actions" -> "apply tuned parameter set"

[DCE · Accepted solution]

Olga,

Bad news
Per the following site - the tune parameters are no longer included

Good news This site have the file to download to get the parameter set

http://web.tampabay.rr.com/batcave/ServerBuilds.htm#Kernel

The old selections for DataBase server kernel changes are not
available in 11i. To have these again, download the following
files and place them in the /usr/sam/lib/kc/tuned directory.
Then start up SAM and select the one you need.

[Patrick Wallek]

If you want to use the kernel parameter sets, MAKE ABSOLUTELY SURE that you set the timeslice parameter back to 10. The tuned parameter sets set the timeslice down to 1, which is ABSOLUTELY STUPID!!!! You don't ever want to touch timeslice. It should stay at 10!

[Olga_1]

Thank you all