Showing posts with label kill sessions. Show all posts
Showing posts with label kill sessions. Show all posts

Tuesday, September 13, 2011

Kill sessions for a certain schema / user

select 'alter system kill session ''' || sid || ',' || serial# || ''';' from v$session where username = ''