Skip to content

Instantly share code, notes, and snippets.

@jpirir

jpirir/kill_session.sql

Last active November 1, 2019 00:37
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jpirir/5ea36890029f485d8d392b42e3d6ea86 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jpirir/5ea36890029f485d8d392b42e3d6ea86 to your computer and use it in GitHub Desktop.
Download ZIP
select to kill session oracle
Raw
kill_session.sql
select 'alter system kill session '''||sid||','||serial#||''''||' immediate'||';'
from v$session
where username = '';
@jpirir

jpirir commented Nov 1, 2019

Copy link
Copy Markdown
Author

Add immediate

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment