Re: Orphan Processes On SQL*Net 2.1.3

From: Ken Mutchell <lbebs_at_cix.compulink.co.uk>
Date: Tue, 31 Jan 1995 14:52:05 GMT
Message-ID: <D39yMt.Cru_at_cix.compulink.co.uk>


We're on an earlier version of SQL, but we still have the problem of orphan processes. We've found the only successful way of getting rid of them is to kill them manually. The following bit of SQL allows you to see which operating system process belongs to which user, of the users logging on via SQL*Net. You can then delete the process which you think is orphaned.

select s.username, p.spid
from v$session s, v$process p
where s.paddr = p.addr
and p.username = '?'
Hope this helps.

Barbara Received on Tue Jan 31 1995 - 15:52:05 CET

Original text of this message