How to kill sessions manually
12 Oct 2010Query to get SID and SERIAL#: SELECT sid, serial#, username FROM v$session
> > Optionally filter WHERE username=.... > >
Once you found the one to kill: ALTER SYSTEM KILL SESSION ‘[sid],[serial#]’
Generate kills for all connections for a given user: SELECT ’alter system kill session ‘’’ | sid | ’,’ | serial# | ’’’;’ FROM v$session WHERE Username = ‘MAKODEMO’; |