Re: How do you KILL a runaway session?

Dean R Money (dmoney_at_magnus.acs.ohio-state.edu) wrote:
:*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.

Go into sqldba, connect internal, and then run monitor. One of the options in monitor will allow you to suspend a process. Received on Tue Jan 25 1994 - 23:48:16 CET