OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Kill many session (Oracle 10G / Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Kill many session [message #515214]

Fri, 08 July 2011 11:49

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

Hi every body,

I want to know if it's possible , in the syntax of :

ALTER SYSTEM KILL SESSION ...

to specify a group of sessions, such as all sessions belonging to a particular user,

for example

ALTER SYSTEM KILL SESSION ... WHERE USERNAME='SCOTT';

or some thing like this.

Thanks

Report message to a moderator

Re: Kill many session [message #515215 is a reply to message #515214]

Fri, 08 July 2011 12:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>to specify a group of sessions, such as all sessions belonging to a particular user,
not directly

conn / as sysdba

set heading off
set termout off
set verify off
set echo off
set feedback off

ALTER SYSTEM enable restricted session;

ALTER SYSTEM checkpoint global;

spool kill_all.sql

SELECT 'execute kill_session('|| chr(39) || sid || chr(39) || ',' || chr(39) || serial# || chr(39) || ');'
FROM gv_$session
WHERE (username = 'SCOTT');

spool off

@kill_all

Report message to a moderator

Re: Kill many session [message #515217 is a reply to message #515215]

Fri, 08 July 2011 12:37

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

or rather:

connect system/manager
set heading off
set termout off
set verify off
set echo off
set feedback off
spool kill_scott.sql
SELECT 'alter system kill session '''|| sid || ',' || serial# || ''';'
FROM v$session
WHERE username = 'SCOTT';
spool off
@kill_scott

Regards
Michel

Report message to a moderator