Multiple _kill session example

Multiple kill session example

SCHEMAS

 select 'alter system kill session '''||SID||','||SERIAL#||''' immediate;' from v$session where username='<schema_name>';

Session with username not sys

set pagesize 200

select  'alter system kill session '''|| sid||','||serial#||''' immediate ;' from v$session  where type <> 'BACKGROUND' and username <> 'SYS';

SQL ID 

SQL>select 'alter system kill session '''||SID||','||SERIAL#||''' immediate;' from v$session where sql_id='1amhfbhjmfn6y';