Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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