Alter system kill session

From Ittichai Chammavanijakul's Wiki

Revision as of 09:42, 15 August 2020 by Ittichai (talk | contribs) (Created page with "<pre> set pagesize 0 select 'alter system kill session ''' || SID || ',' || serial# || ''';' from v$session where username like 'EZ%'; </pre> Category: SQL Scriopts")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

set pagesize 0
select 'alter system kill session ''' || SID || ',' || serial# || ''';'  
from v$session where username like 'EZ%';

Retrieved from "https://ittichaicham.com/wiki/index.php?title=Alter_system_kill_session&oldid=1267"

SQL Scriopts