Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Orphaned process on the server (how to kill..)
Hi:
Could anyone suggest a neat method of killing orphaned Oracle processes
on a Unix server? These hang around when the client application (Windows
3.1 usually) is aborted, usually by a re-boot.
Doing Unix 'ps -fu daemon' gives me a pid, which I can then use to query v$process and v$session. This tells me quite a bit about the parent process, but I was hoping there would be something to say whether the parent process (the Windows app) was still attached or not, so I would definitely know that the Unix process was orphaned. Any ideas?
TIA.
|________________________________________________________________|Received on Mon Feb 17 1997 - 00:00:00 CST