Database Administration (MOSC)

MOSC Banner

oracle Qmnc uses high cpu

edited Dec 21, 2019 4:01AM in Database Administration (MOSC) 3 commentsAnswered

hello, I have an old Oracle production server 10.1, on HPUX ,     Model:      9000/800, HP Container, No RAC,  64GB memory, 8 processor cores, at the time of problem 12GB free. 4 of the 8 cores running over 90%. other 4 cores are ok so average is 30%. We have 4 databases running on this HP container, two are live, two are test, at the time of problem, the test database were not being used, and no entry connected in listener log in past 3 days. only connections were the 2 live databases.

The problem is that since the qmnc is busy on something (high cpu), the child process it spawned are left as defunct zombie processes not being cleaned, it had 3782 zombie processes left by the 4 databases's qmnc processes. brought the oracle processes to 4096 limit according to our current setting. all new connections to oracle databases were failed, even to switch to oracle as su - oracle.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center