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

Eric Hartzenberg wrote:
>
> 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 |
> |________________________________________________________________|

You could pipe 'ps -ef|grep LOCAL' to awk. If $3 = 1, kill -9 $2.

-- 
Thomas Griffin
Project Leader
QUALITECH Systems, Inc.
tgriffin_at_qualitech.com