Re: Killed sessions lock some tables

Alex Filonov wrote:

> In short, you need to kill dedicated server processes of
> these sessions, it would clean them. How to do it under W2K is a
> separate question though...

On Windows, you will find the thread id in the column (v$session or v$process) that carries the Unix PID on a Unix platform.

Using that, you can try and force the thread to terminate. But methinks that will be a bad idea as Windows tend to be like a fine china shop at times. The few times that I used a similar approach (client-side, forcing threads to close), Windows time and again fail to "gracefully" kill the thread like a kill -9 does on Unix. If it was not errors, it was memory leakages.

--
Billy