Operating System - HP-UX
1753781 Members
7530 Online
108799 Solutions
New Discussion юеВ

Oracle creating defunct process

 
RAJESH GANGADHARAN
Regular Advisor

Oracle creating defunct process

Hi
We got Oracle 9.2.0 database server, Now one of the Oracle process is creating defunct process, which I am not able to kill using kill -HUP , These process will get killed once I restart the database instance. After some time again child process are turning into defunct process. Can any one suggest a solution.

Thanks in Adv.
Let the choices you make today be the choices you can live with tomorrow.
2 REPLIES 2
Graham Cameron_1
Honored Contributor

Re: Oracle creating defunct process

Not a good idea to kill any oracle processes unless you are very confident.
However there are some threads on metalink which describe this kind of thing, in relation to dbms_snp processes.
How are they manifesting themselves?
(ie how do they appear in ps -ef)
If you have metalink access, search for "defunct"
-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Printaporn_1
Esteemed Contributor

Re: Oracle creating defunct process

Any error in alert log ?
or in background trace ?
enjoy any little thing in my life