Re: How does the User Kill a Stored Procedure Session?

From: <gmei_at_my-deja.com>
Date: Fri, 01 Sep 2000 21:02:05 GMT
Message-ID: <8op5g0$gvq$1@nnrp1.deja.com>

Start another session, assuming you have DBA priv, issue

"alter system kill session..." command to kill the 1st session.

Guang

In article <8ooq4h$bk6c2$1_at_ID-41926.news.cis.dfn.de>, "Dino Hsu" <dino1_at_ms1.hinet.net> wrote:
> Dear all,
>
> I am testing a program which starts a stored procedure on the
server,
> and wait for its completion. Sometimes the user may want to kill
the
> stored procedure session for some reason, but there seems to
be no
> method for the user to do it. I can see from Instance
Manager
> that the session is still there, even when the user re-
starts his
> or her PC.
>
> Can you tell me the way for the user (not IT) to kill the
> session?
>
> Thanks,
> Dino
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 01 2000 - 16:02:05 CDT