Tuned Kernel Parameter Sets and Oracle 8

[Rui Vilao]

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.

[James R. Ferguson]

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 · Accepted solution]

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]

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]

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.

[Jesper Sivertsen]

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