Oracle pmon process comsuming 99.99 cpu usage

[Jayraj]

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

[likid0]

the quick and ugly:

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

[Dennis Handly · Accepted solution]

>Orange_adm: the quick and ugly:

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

[likid0]

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

;D.

[Steven E. Protter]

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

[Suraj K Sankari]

Hi,

If possible then shutdown the DB and restart the server.


Suraj

[Jayraj]

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..

[Jayraj]

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

[Hein van den Heuvel]

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.

[Dennis Handly]

>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