Find Blocking Session details

How to find Oracle Database Blocking Session Details

In first step, find SID from v$session.

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

PROCESS SID BLOCKING_SESSION

———— ———‐ —————‐

1234 365 366

1234 366 365

In second step find the serial number for the Blocking Session to kill using SID

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

SERIAL#

———‐

130

In third step, kill the blocking session using SID and serial number

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

System altered.