How do you KILL a runaway session?
Often, when one of my application programs (under development) crash
or hang, I have to kill the Unix session. The problem is that the
Oracle session is not necessarily dead, and thus ties up the objects
it had been working on (i.e. tables, rollback segments, etc.). I
look at v$session, and see the session is still active. I try to
KILL the session using ALTER SYSTEM KILL SESSION ( sid, serial# ),
but can't "catch" the session, because the serial# continually
changes.
Is there another way to kill this session, other than bringing the
db down ;-)? I know that if I wait it out, it seems to die on
its own, but this can sometimes take an hour or more.
Any help would be greatly appreciated!
Dean.
Received on Tue Jan 25 1994 - 22:44:10 CET
Original text of this message