Dear All,
We are using 10g database with a JAVA based application. Our DBA team is complaining that there are lot of Zombie processes getting created in DB, which is consuming large CPU.
The term "Zombie" is new to me. I have searched in Google and in metalink, but not getting clear ideas. Request the Gurus help in identifying the issues. The the questions in my mind are..
1. How dangerous is Zombie process.
2.Is there any way to find out how they are getting created?(Which query?/Which program?/Which process?...)
3.What is the solution to avoid zombies getting created?
Below are the DB details.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
"CORE 10.2.0.4.0 Production"
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
----------------------------------------------------------------------
[oracle@csfproddb ~]$top
top - 07:36:00 up 117 days, 3:25, 0 users, load average: 0.19, 0.18, 0.10
Tasks: 222 total, 3 running, 204 sleeping, 0 stopped, 15 zombie
Cpu(s): 12.0%us, 1.0%sy, 0.0%ni, 82.0%id, 4.9%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 8176308k total, 8129636k used, 46672k free, 136236k buffers
Swap: 10241428k total, 99300k used, 10142128k free, 7044488k cached
oracle 2341 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 2342 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 2895 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 3833 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 4510 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 4531 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 9294 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 13063 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 16035 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 16880 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 17080 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
root 18190 1 0 2011 ? 00:01:06 [emcpdefd]
oracle 19392 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 23499 4284 0 Jan31 ? 00:00:00 [zip] <defunct>
oracle 32036 4284 0 07:32 ? 00:00:00 [zip] <defunct>
oracle 32244 4284 0 07:32 ? 00:00:00 [zip] <defunct>
Thanks in Advance
Edited by: 884476 on Jan 31, 2012 9:48 PM