FIND AND KILL BLOCKING SESSIONS IN ORACLE

1.  To find blocking session jobs below query will useful. It will return two rows.
select process,sid, blocking_session,SERIAL# from v$session where blocking_session is not null;
E.g.
SQL> select process,sid, blocking_session, serial# from v$session where blocking_session is not null;
PROCESS SID BLOCKING_SESSION SERIAL#
———— ———- —————- ———-
1234        365                       366      130


2.  Final step to kill the blocking session
alter system kill session ‘SID,SERIAL#’;
E.g.
SQL> alter system kill session '365,130';
System altered.