Re: How to kill Oracle connection?

Hoi, thanks for help.

But the problem is not solved yet.

In Unix, we can find out the session and the corresponding process.

But on Windows NT, a thread (with thread id ) is created to connect to Oracle. But in Oracle it seems to have another thread id which is not the same as original thread id.

So, how can I find out which session belongs to which thread.

thanks

Xu

In article <35817673.0_at_news.cadvision.com>,   "Terry Dykstra [TeamPS]" <no_spam_tdykstra_at_cfol.ab.ca> wrote:
>
> To kill a user use "alter system kill session ' sid#, serial#' "
> where you can get the sid# and serial# from the v$session table./
>
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
> su_xu_at_my-dejanews.com wrote in message <6lqphs$dph$1_at_nnrp1.dejanews.com>...
> >
> >
> >Hi, All
> >
> >Can anybody tell me how to kill a closed Oracle connection on Windows NT ?
> >
> >Several applications are connected to Oracle 7.3 on Windows NT and
> >one of them should be killed because of Time-out. But when one main process
> >is killed, the corresponding Oracle connection thread will not be killed
> >automatically!
> >
> >The question is:
> > How to find out which Oracle thread is from your application?
> > and How to kill it?
> >
> >Thanks a lot for help.
> >
> >Xu
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 15 1998 - 03:28:27 CDT