Killing a running Procedure?

From: Sean <dolans_at_my-deja.com>
Date: Wed, 03 Jan 2001 15:43:47 GMT
Message-ID: <92vhbi$6jv$1@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 - 09:43:47 CST