Re: Killing a running Procedure?

1. hardcore Query Oracle views v$session, v$sqlarea, v$sqltext, e.g. showing statements in the shared-pool currently being processed:

SELECT b.address, b.sql_text, sorts, users_executing FROM v$sqlarea a, v$sqltext b
WHERE a.hash_value = b.hash_value and users_executing > 0 ORDER BY b.address, piece, sorts, users_Executing;

b) convenient way: use oracle enterprise manager

Klaus

Sean <dolans_at_my-deja.com> schrieb in im Newsbeitrag: 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 Fri Jan 05 2001 - 06:48:50 CST