Re: kill session doesn't work?

<twoplustwo_at_my-deja.com> wrote in message news:94vmkf$jka$1_at_nnrp1.deja.com...
> Hi guys thanks for the help...
> I did try "alter system" ... with no spaces and I thought the session
> was still running because I could still see it in v$session.
> Someone pointed out that may not be true.... even thought it looks like
> it is connectted, it is not (or not doing any work) right?????
>
> So I guess I can just leave it there...since I neither want to reboot
> the instance or want to kill the unix process....
>
>
> TwoPlusTwo
>

Yeah, well.... how about testing that it really *has* worked!!?? I hate to see DBAs 'guessing' anything, ok!

Get that session to do a simple select: select user from dual would do it.

Until that session reports "Your session has been terminated", you can't really be sure, can you?

Regards
HJR
>
> In article <94vd9a$c23$1_at_nnrp1.deja.com>,
> twoplustwo_at_my-deja.com wrote:
> > My Oracle instance is running on unix
> >
> > WHen I try .....
> > alter system kill session ' 596, 21456' ;
> >
> > The session continues to run...
> > What else can I do to try to kill this session..?
> >
> > Thanks TwoplusTwo
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Jan 27 2001 - 18:05:24 CST