General
cancel
Showing results for 
Search instead for 
Did you mean: 

Tuned Kernel Parameter Sets and Oracle 8

SOLVED
Go to solution
Rui Vilao
Regular Advisor

Tuned Kernel Parameter Sets and Oracle 8

Greetings,

I am currently trying to install Oracle 8.1.6 on a K380
running HP-UX 11 (64 bit).

The default kernel parameters are not enough...

My target host will be a RDBMs running two database instances with 50
simultaneous users and a total of 1000Gb:

Available Tuned Kernel Parameter Sets are:

* General OLTP/Database Client System
* General OLTP/Database Monolithic System
* General OLTP/Database Server System

What is the meaning of these sets (eg. difference between Client, Monolithic and
Server System).

Thanks in advance for your help,

Kind Regards,

Rui.
"We should never stop learning"_________ rui.vilao@rocketmail.com
5 REPLIES
James R. Ferguson
Acclaimed Contributor

Re: Tuned Kernel Parameter Sets and Oracle 8

Hi:

Start with the 'server' template, just as a guide. If you have Glance, monitor your general performance. If you don't have Glance, get it, it's worth its weight in gold.

This thread is a good starting point for your tuning efforts:

http://my1.itrc.hp.com/cm/QuestionAnswer/1,1150,0xeb737e990647d4118fee0090279cd0f9,00.html

For general kernel tuning, see:

http://docs.hp.com/hpux/onlinedocs/os/KCparams.OverviewAll.html

...JRF...
James R. Ferguson
Acclaimed Contributor
Solution

Re: Tuned Kernel Parameter Sets and Oracle 8

Hi (again);

BTW, the template files used for kernel configuration are located in /usr/sam/lib/kc/tuned/ . Thus, you could compare the differences easily.

...JRF...
John Palmer
Honored Contributor

Re: Tuned Kernel Parameter Sets and Oracle 8

Hi,

General OLTP/Database Server System is a good start to configuring a database server system but it has some limitations that you ought to correct:-

1) it assumes that you will be using raw I/O and consequently configures a small fixed size buffer cache. Set bufpages back to 0 and adjust dbc_min_pct and dbc_max_pct to appropriate values.

2) it disables pseudo-swap. Set swapmem_on back to 1.

3) it changes the CPU timeslice from 10 to 1ms, put it back to 10.

You may want to adjust some other parameters such as maxusers.

What I do is to compare the 'current' and 'pending' values of all the parameters and investigate those that have changed.

Hope this helps,
John
CHRIS ANORUO
Honored Contributor

Re: Tuned Kernel Parameter Sets and Oracle 8

Check the help on the kernel parameter screen for the meanings. I have oracle 8.0.5.2.2 running on a 10.20 server with 1Gb ram and 2.5Gb of swap space. You can look at the attached kernel file for assistance.
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
Jesper Sivertsen
Frequent Advisor

Re: Tuned Kernel Parameter Sets and Oracle 8

Hi there

I normaly uses:
General OLTP/Database Monolithic System

This works fine for several instances on the same machine, but if you install Oracle 8.1.6 64 bit you have to increase maxdsize to 200 Mb to relink oracle.

God luck
All in unix is files