topic Re: How to Apply General OLTP/Database Kernel Parameter Set? in Operating System - HP-UX

How to Apply General OLTP/Database Kernel Parameter Set?

Olga_1 — Fri, 15 Dec 2006 17:06:07 GMT

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.

Re: How to Apply General OLTP/Database Kernel Parameter Set?

Berd — Mon, 18 Dec 2006 11:47:12 GMT

Olga,

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

Berd

Re: How to Apply General OLTP/Database Kernel Parameter Set?

Olga_1 — Mon, 18 Dec 2006 11:51:19 GMT

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

Thank you

Re: How to Apply General OLTP/Database Kernel Parameter Set?

Berd — Mon, 18 Dec 2006 12:05:18 GMT

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

Re: How to Apply General OLTP/Database Kernel Parameter Set?

Olga_1 — Mon, 18 Dec 2006 12:18:11 GMT

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

Re: How to Apply General OLTP/Database Kernel Parameter Set?

Berd — Mon, 18 Dec 2006 12:29:49 GMT

Olga,

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

Re: How to Apply General OLTP/Database Kernel Parameter Set?

Olga_1 — Mon, 18 Dec 2006 12:32:21 GMT

Itanium HP11i v2

Re: How to Apply General OLTP/Database Kernel Parameter Set?

OldSchool — Mon, 18 Dec 2006 12:36:13 GMT

Olga,

Does the following work for you?

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

Re: How to Apply General OLTP/Database Kernel Parameter Set?

DCE — Mon, 18 Dec 2006 12:54:35 GMT

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.

Re: How to Apply General OLTP/Database Kernel Parameter Set?

Patrick Wallek — Mon, 18 Dec 2006 13:15:57 GMT

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!

Re: How to Apply General OLTP/Database Kernel Parameter Set?

Olga_1 — Mon, 18 Dec 2006 13:38:59 GMT

Thank you all