OLTP tuned parameter sets for 11i

[Dan Bolton]

We are currently setting up an rp7410, running 11i, for a database application. Our current servers are all running 11.00. When I went to SAM to apply the OLTP Tuned Parameter Set as had been done on the previous systems, the OLTP sets were not listed. I compared /usr/sam/lib/kc/tuned and found the oltp_*.tun files do not exist on the 11i box, only the eng workstation .tun files are there.

I am considering the following options:

1) Can the missing *.tun files be loaded from the install CD or found somewhere else?

2) Could I use the *.tun files from an 11.00 install?

3) Would a template created from our 11.00 box work on the 11i kernel?

Any suggestions would be greatly appreciated.
Dan

[A. Clay Stephenson · Accepted solution]

Avoid those OLTP Tuned Parameter Sets like the plague. Everyone of those (which were intentionally omitted from 11.11) set timeslice to 1 (rather than 10). As the machine begins to load, the box will do context switching and very little else.

I've always found that you can do much better on your own than these things.

[Dan Bolton]

Clay -

I am aware that there are some settings that will need to be changed from the tuning set default, just wanted to get "in the ballpark" and tune from there. Can the current parms from our 11.00 box be used as a SAM "template", or am I best off just printing the current parms and adjusting each manually?

Thnx,
Dan

[A. Clay Stephenson]

Because the workstation TUN's compare very closely between 11.0 and 11.11, I strongly suspect that you could copy them over; however, if this were me, I would do a kmtune on a good 11.0 box and manually change the 11.11 to closely. In many cases, I blow away most of the formulae and enter values directly.

Above all, leave timeslice VERY NEAR 10.