How to kill a session quick

This shows you how to kill sessions completely in UNIX and NT.

http://www.oracle-base.com/Articles/...leSessions.asp

In NT you need to use the orakill utility to kill the offending thread. Remeber, Oracle on NT is a single process with multiple threads, so you actually kill a thread not a process.

Cheers

For NT use Microsoft's qslice utilty in order to get the spid of a processs.

Ravinder