Skip to content

Instantly share code, notes, and snippets.

@mjbommar

mjbommar/kill_sessions_by_module_machine.sql

Created June 15, 2013 12:59
Show Gist options
  • Save mjbommar/5788046 to your computer and use it in GitHub Desktop.
Save mjbommar/5788046 to your computer and use it in GitHub Desktop.
Download ZIP
Generate a script to kill (IMMEDIATE) all sqlplus sessions from a given host.
Raw
kill_sessions_by_module_machine.sql
SELECT 'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || ',@' || inst_id || ''' IMMEDIATE;'
FROM gv$session
WHERE module = 'SQL*Plus'
AND machine = 'host.company.com';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment