Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: processes not dying show killed forever
Hi !!
Did you kill it with a UNIX command ? That seems to be the problem at our shop also.
Get the SID and SERIAL_NO for that process by selecting from v$session.
and then use;
alter system
kill session ' &SID, &SERIAL_NO'
/
As to why he crashes, I can't say !!
Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com
dean_at_gfsmortgage.com wrote in article <6u6686$fmt$1_at_nnrp1.dejanews.com>...
> I have a developer that keeps crashing his system and reconnecting to my
> Oracle server.
>
> He has six connections showing as inactive. I killed one of his
processes
> hours ago, but it still shows up( as killed).
>
> I know how to treat the symptom, but not the cause.
>
> Any hints or suggestions?
>
> Thanks
>
> -Dean
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Mon Sep 21 1998 - 16:47:57 CDT