Re: how to kill a session properly while running server codes

From: Dr. Jan Dieckmann <jdieckmann_at_psi.de>
Date: Tue, 05 May 1998 14:29:32 +0200
Message-ID: <354F062C.3C04@psi.de>

Terry Dykstra [TeamPS] wrote:
>
> Take a look at the 'alter system kill session' command.
>
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
> Harry Yuen wrote in message <354d596a.861398297_at_news.istar.ca>...
> >Recently I had to terminate some server running program by means of
> >rebooting the client PC. I tried to truncate some tables afterward
> >but got a message saying the resource is busy.
> >Is there a better way to take care of session killing without getting
> >the same effect? As for resource busy, what is available other than
> >restarting the instance? Is kiiling a session a DBA only task?
> >Thanks in advance.
> >
> >Harry Yuen

Our tool Hora 3 shows on the session page important informations about all sessions including User, Client, Server PID, PID ...

Lines of Lock holding ore Pipe sending sessions are colored red. You also see the SQL statement the selected session is executing. You can kill a session by executing the command Kill Session.

You can download a trialversion of Hora 3 at

http://www.keeptool.com

regards Jan Dieckmann KeepTool GbR
Jan.Dieckmann_at_KeepTool.com Received on Tue May 05 1998 - 07:29:32 CDT