Re: killing a 'killed' session

select p.spid
from v$process p, v$session s
where s.paddr = p.addr
and s.sid = &1

kill -9 what it returns
(if not mts, with mts u'd have to kill that server i think) u can also try sqlnet.ora parameter SQLNET.EXPIRE_TIME alter system kill session sucks.

On Thu, 20 Mar 2003 21:59:13 GMT, "Tom" <tomNOSPAM_at_teameazyriders.com> wrote:

>Solaris 7
>Oracle 8.1.5
>
>Hi group
>
>we have an annoying problem with one of our applications in that every 5 to
>10 days or so the JVM will lock up and have to be killed and restarted. This
>causes the oracle connections from the app to just hang around as inactive.
>I have gone through and killed them but they seem to just stay in v$session
>and never get cleaned up.
>
>My questions are what can i do to remove these killed sessions short of
>bouncing the database and even though they are killed are they taking up any
>resources?
>
>thanks
>
>Tom
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Mar 20 2003 - 16:20:38 CST