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

Search

Loading... Please wait

Subscribe to our Newsletter

Be a sport and

x