topic Re: Kernel params - Multi-Instance - Oracle 9i in Operating System - HP-UX

Kernel params - Multi-Instance - Oracle 9i

Court Campbell — Mon, 19 Feb 2007 12:11:17 GMT

Currently my company has 7 x 9i instances on one box. The box has more than enough horsepower to run them. I am concerned that the kernel params may need to be tweaked for the number of instances running. The current params are set to the Oracle recommended params for a single instance. I was curious if anyone knows which params would have the greatest affect for a box running multiple instances. I

Re: Kernel params - Multi-Instance - Oracle 9i

Rita C Workman — Mon, 19 Feb 2007 13:17:16 GMT

Hi Court,

There is not enough information to answer your question. If your running 7 instances and they are all working with nobody complaining about performance, then I'd say you might be just fine.
If you see performance problems...then you'll have to supply the group more information to work with.
SGA of instances
More info on the hardware configuration
What are parms set to now

...what kind of problem are you seeing (if any).

You can have 7 instances and be working fine, or just 1 instance and it's choking.
Frankly, I use Oracle parm recommendations as a 'suggestion', but sometimes I absolutely disagree with what they want and have found UNIX Admin's tend to know more about tuning the kernel than a DBA.

Let us know specifics....
Rgds,
Rita

Re: Kernel params - Multi-Instance - Oracle 9i

Court Campbell — Fri, 23 Feb 2007 10:37:37 GMT

The info was not super helpful but it did lead me to a new outlook on monitoring system performance. I have been fighting myself for years on the fact that tuning and performance is more of an art than an exact science.