sql developer kill query

Solutions on MaxInterview for sql developer kill query by the best coders in the world

showing results for - "sql developer kill query"
Luca
24 Jan 2017
1-- Get ORACLE Session IDs (SID and SERIAL#)
2SELECT SID, SERIAL#, STATUS, SERVER FROM V$SESSION WHERE USERNAME = '<username>';
3-- Kill session (and wait for rollback if any...)
4ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;