topic Re: Oracle pmon process comsuming 99.99 cpu usage in Operating System - HP-UX

Oracle pmon process comsuming 99.99 cpu usage

Jayraj — Wed, 17 Dec 2008 10:20:01 GMT

Hi all,

when I typed top Command I can see many oracle processes running, consuming lot of cpu usage. the related database is shutdowned currently still they are showing in top command
.. Is there any command can kill all the processes of perticular user

Re: Oracle pmon process comsuming 99.99 cpu usage

likid0 — Wed, 17 Dec 2008 10:54:49 GMT

the quick and ugly:

kill -9 $(ps -ef | grep -v grep | grep USER | awk '{ print $2 }')

Re: Oracle pmon process comsuming 99.99 cpu usage

Dennis Handly — Wed, 17 Dec 2008 11:05:54 GMT

>Orange_adm: the quick and ugly:

A little safer, add -9 if it fails:
kill $(UNIX95=EXTENDED_PS ps -fu USER -opid=)

Re: Oracle pmon process comsuming 99.99 cpu usage

likid0 — Wed, 17 Dec 2008 11:21:43 GMT

Yep Dennys, good point, allways start with a kill.

;D.

Re: Oracle pmon process comsuming 99.99 cpu usage

Steven E. Protter — Wed, 17 Dec 2008 12:04:15 GMT

Shalom,

Might be better to shut down the database than to kill the pmon process and thus leave everything else running.

The common source of this problem are bugs in Oracle which will require you to patch oracle.

SEP

Re: Oracle pmon process comsuming 99.99 cpu usage

Suraj K Sankari — Wed, 17 Dec 2008 12:06:09 GMT

Hi,

If possible then shutdown the DB and restart the server.

Suraj

Re: Oracle pmon process comsuming 99.99 cpu usage

Jayraj — Wed, 17 Dec 2008 12:23:10 GMT

trace of top output

1 ? 10617 root 148 20 32K 32K zomb 1:28 98.93 98.75 samx

I have tried killing samx also again its coming...
kill -9 10617
what could be the problem..

Re: Oracle pmon process comsuming 99.99 cpu usage

Jayraj — Wed, 17 Dec 2008 13:02:02 GMT

Here is the output of the top command
hope this may help better...
CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
3 ? 12752 oracle 133 20 32K 32K zomb 43:33 100.37 100.20 ora_pmon_hp4ora10
0 ? 13273 oracle 133 20 32K 32K zomb 115:17 100.34 100.16 ora_pmon_testdb
0 ? 13206 oracle 240 20 224M 5196K run 322:39 100.16 99.98 ora_pmon_hp4ora10
1 ? 13239 oracle 240 20 222M 4492K run 156:08 100.16 99.98 ora_qmnc_hp4ora10
2 ? 1 root 240 20 496K 204K run 4204:38 100.11 99.94 init
1 ? 10617 root 148 20 32K 32K zomb 1:28 98.93 98.75 samx
2 ? 16034 oracle 133 20 32K 32K zomb 6002:31 80.15 80.01 ora_qmnc_hp4dev03
3 ? 17583 oracle 133 20 32K 32K zomb 6033:50 79.97 79.83 ora_qmnc_hp4ora10
0 ? 13780 moharanj 133 20 32K 32K zomb 5740:42 76.61 76.48 ora_qmnc_testdb
3 ? 17552 oracle 149 20 32K 32K zomb 4687:38 39.49 39.43 ora_pmon_hp4ora10
0 ? 17662 oracle 133 20 32K 32K zomb 4540:46 35.46 35.40 ora_pmon_hp4char2
0 ? 12998 oracle 149 20 32K 32K zomb 0:07 29.03 28.98 ora_m000_hp4ora10
1 ? 23376 moharanj 149 20 32K 32K zomb 0:07 28.71 28.66 ora_m000_testdb
3 ? 16004 oracle 133 20 32K 32K zomb 4702:14 27.06 27.02 ora_pmon_hp4dev03
2 ? 13756 moharanj 133 20 32K 32K zomb 3675:20 20.98 20.95 ora_pmon_testdb
3 ? 17699 oracle 149 20 32K 32K zomb 1:49 19.59 19.56 ora_mmon_hp4char2
3 ? 28255 moharanj 241 20 32K 32K zomb 0:09 15.98 15.95 ora_m000_testdb
0 ? 28434 moharanj 149 20 32K 32K zomb 0:02 14.35 14.32 ora_m000_testdb
3 ? 24640 moharanj 149 20 32K 32K zomb 0:02 14.28 14.26 ora_m000_testdb
3 ? 23922 moharanj 149 20 32K 32K zomb 0:02 14.22 14.19 ora_m000_testdb
3 ? 24342 moharanj 149 20 32K 32K zomb 0:02 14.05 14.02 ora_m000_testdb
0 ? 23719 moharanj 149 20 32K 32K zomb 0:02 13.97 13.95 ora_m000_testdb
3 ? 28498 moharanj 149 20 32K 32K zomb 0:02 13.97 13.94 ora_m000_testdb
2 ? 28695 moharanj 149 20 32K 32K zomb 0:02 13.91 13.88 ora_m000_testdb
1 ? 28371 moharanj 149 20 32K 32K zomb 0:03 13.77 13.75 ora_m000_testdb
2 ? 22202 moharanj 149 20 32K 32K zomb 0:02 13.77 13.74 ora_m000_testdb
3 ? 24121 moharanj 149 20 32K 32K zomb 0:02 13.76 13.73 ora_m000_testdb

Re: Oracle pmon process comsuming 99.99 cpu usage

Hein van den Heuvel — Wed, 17 Dec 2008 13:18:45 GMT

Lot's of zombies out there.
They want to say goodbye, but no (parent) process is listening.

Sounds like processes were killed in the wrong order.

Maybe a wrong database was shut down?

Be sure to check the tails of all Oracle alert logs. They may reveal a real problem.

And, you probably already know this, but in case you did not... Oracle has flavors of shutdown:
- no options... wait nicely for all users to go.
- IMMEDIATE... kill users then shutdown nicely.
- ABORT... kill processes in optimal order and do not bother to clean up other then trying to get rid of IPC resources (SGA).

good luck,
Hein.

Re: Oracle pmon process comsuming 99.99 cpu usage

Dennis Handly — Wed, 17 Dec 2008 22:41:40 GMT

>trace of top output
>1 ? 10617 root 148 20 32K 32K zomb 1:28 98.93 98.75 samx
>I have tried killing samx also again its coming.

You can't kill zombies, they are dead. You can only kill the zombie master.

What does this show:
UNIX95=EXTENDED_PS ps -Hfp 10617 -p 12752 -p 13273 -p 28255

Re: Oracle pmon process comsuming 99.99 cpu usage

Jayraj — Fri, 20 Feb 2009 13:11:25 GMT

Thank you all