"Sean" <dolans_at_my-deja.com> wrote in message
news:92vhbi$6jv$1_at_nnrp1.deja.com...
> Platform: Oracle 8.1.7 EE (no Java) on NT 4.0 SP6a.
>
> Question: I have a Stored Procedure that is called and takes WAY TOO
> long to run (upwards of 3 minutes), but that is not the point of this
> question. It does successfully complete but I was wondering if there
> was a way as the sysadmin to query something that would show me if the
> procedure is currently running. And then if so, how could I kill it so
> as to free up resources? The reason is that the client sometimes will
> get the procedure started but then leave (via their web browser) and I
> am wondering if the procedure is still running in the background.
>
> Thanks,
> Sean
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Jan 03 2001 - 17:52:32 CST
