Sql query to locate and destroy Oracle Database Blocking Session

Sql query to  locate  and destroy Oracle Database Blocking Session

  
Locate SID from v$session.

select process,sid, blocking_session from v$session where blocking_session is not null;

Locate the serial number for the Blocking Session to kill using SID

SQL> select SERIAL# from v$session where SID=509;

SERIAL#

1799

Destroy the blocking session using SID and serial number

SQL> alter system kill session ’365,130′;