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

Dear Guan,

"alter system kill session" is what IT can do, not what the user can do. In other words, the users cannot count on the IT to kill the sessions all the time. Thanks anyway.

Regards,
Dino

<gmei_at_my-deja.com> ¼¶¼g©ó¶l¥ó news:8op5g0$gvq$1_at_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 - 23:20:30 CDT