-- select blocking session

select

blocking_session,

sid,

serial#,

wait_class,

seconds_in_wait,

'ALTER SYSTEM KILL SESSION ''|| sid || ',' serial# || ''' ||' IMMEDIATE;' as command

from

v$session

where

blocking_session is not NULL

order by

blocking_session;

-- kill session

--ALTER SYSTEM KILL SESSION 'sid,session#' IMMEDIATE;

--ALTER SYSTEM KILL SESSION '12,16607' IMMEDIATE;