Skip to content

Instantly share code, notes, and snippets.

@caiogallo

caiogallo/gist:4733003

Last active August 19, 2016 18:14
Show Gist options
  • Save caiogallo/4733003 to your computer and use it in GitHub Desktop.
Save caiogallo/4733003 to your computer and use it in GitHub Desktop.
Download ZIP
Search oracle blocking sessions and generate alter kill session script
Raw
gistfile1.txt
select 'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || ''' immediate;'
from
v$session
where
username in ('DEV6SVT_MDS')
order by
blocking_session;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment