Re: Kill Process for a Username

Here is the statement you can run :

spool aa;
SELECT 'ALTER SYSTEM KILL SESSION ' || '''' || S.SID || ',' ||S.SERIAL# ||
'''' FROM V$SESSION S where username = 'SYS';

Replace 'SYS' with the name of the user whom you want to kill. Run the spooled output file in SQLPlus. All of the processes should get killed for the user.
Please let me know if this does not work.

On Fri, 09 Feb 2001 00:26:51 GMT, Charles Davis <Stratford2000_at_home.net> wrote:

>Hi,
>
>I am new to Oracle and to this newsgroup. Forgive me if this question
>has already been answered.
>
>Can anyone here supply a script or a process to follow to easily kill
>all the sid's for a specific username, instead of typing in the sid and
>serial# for each and every one of them?
>
>Many thanks.
>
>Charles
  Received on Tue Feb 13 2001 - 06:53:05 CET