Operating System - HP-UX
1827752 Members
3212 Online
109969 Solutions
New Discussion

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