System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle pmon process comsuming 99.99 cpu usage

SOLVED
Go to solution
Jayraj
Frequent Advisor

Oracle pmon process comsuming 99.99 cpu usage

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
10 REPLIES
likid0
Honored Contributor

Re: Oracle pmon process comsuming 99.99 cpu usage

the quick and ugly:

kill -9 $(ps -ef | grep -v grep | grep USER | awk '{ print $2 }')
Windows?, no thanks
Dennis Handly
Acclaimed Contributor
Solution

Re: Oracle pmon process comsuming 99.99 cpu usage

>Orange_adm: the quick and ugly:

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

Re: Oracle pmon process comsuming 99.99 cpu usage

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

;D.
Windows?, no thanks
Steven E. Protter
Exalted Contributor

Re: Oracle pmon process comsuming 99.99 cpu usage

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Suraj K Sankari
Honored Contributor

Re: Oracle pmon process comsuming 99.99 cpu usage

Hi,

If possible then shutdown the DB and restart the server.


Suraj
Jayraj
Frequent Advisor

Re: Oracle pmon process comsuming 99.99 cpu usage

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
Frequent Advisor

Re: Oracle pmon process comsuming 99.99 cpu usage

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
Honored Contributor

Re: Oracle pmon process comsuming 99.99 cpu usage


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
Acclaimed Contributor

Re: Oracle pmon process comsuming 99.99 cpu usage

>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
Jayraj
Frequent Advisor

Re: Oracle pmon process comsuming 99.99 cpu usage

Thank you all