Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Orphaned process on the server (how to kill..)

Orphaned process on the server (how to kill..)

From: Eric Hartzenberg <eric_at_erichome.demon.co.uk>
Date: 1997/02/17
Message-ID: <QNCAiDASGNCzEw2N@erichome.demon.co.uk>#1/1

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.



| ~~~~~~~~~~~~~~~~~~~~ | ERIC HARTZENBERG | ~~~~~~~~~~~~~~~~~~~ |
| Email : eric_at_erichome.demon.co.uk Compuserve : 100073,21 |
| Homepage : www.erichome.demon.co.uk |
|________________________________________________________________|
 
Received on Mon Feb 17 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US