Oracle Script to create dynamic kill command

The script will dynamically generate SQL when required to kill more sessions that will fit your predicate search.

select 'alter system kill session ''' || u.sid || ',' || u.serial# || ''';'
  from v$session u
 where u.type = 'USER'
   and u.module like '%<module>%;

Leave a comment or a question in the comment area bellow if you fell like

Be a sport and


Loading... Please wait

Subscribe to our Newsletter

Be a sport and