WLM and Oracle 9i Configurations

[James Specht]

We have run WLM on HPUX 11i and Oracle 8 for over a year and a half without problems. Once we upgraded to oracle 9i we started seeing problems with WLM giving away too many CPU shares to our production instance of oracle to the point where the rest of the box is almost dead in the water. It never gives back the shares once it reaches the max value. We have to stop and restart WLM to clean the mess up. The logs show very high return times on the performance testing sql we run when it starts, but it returns to normal values pretty quickly, it's just that WLM won't give back the CPU shares. This happens several times a day and night. I got tired of sshing in in the middle of the night so I have turned off WLM, which has removed the problem, but has added others of course.

Has anyone run into this before with WLM and any other application? Or does anyone with a working setup of WLM and oracle 9i wish to share their WLM configuration and/or sql if applicable?

Thanks in advance.

-Jim

[Alzhy]

Have you approached Oracle for support yet?

I know 9i supports practically all of HP-UX 11i's resoruce management tools like PSETS and WLM.