topic Re: Oracle creating defunct process in Operating System - HP-UX

Oracle creating defunct process

RAJESH GANGADHARAN — Thu, 23 Oct 2003 02:21:06 GMT

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.

Re: Oracle creating defunct process

Graham Cameron_1 — Thu, 23 Oct 2003 02:42:35 GMT

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

Re: Oracle creating defunct process

Printaporn_1 — Mon, 27 Oct 2003 05:06:45 GMT

Any error in alert log ?
or in background trace ?