jpirir/kill_session.sql

Last active November 1, 2019 00:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jpirir/5ea36890029f485d8d392b42e3d6ea86.js"></script>
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 = '';

Author

jpirir commented Nov 1, 2019

Add immediate

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