Viswamitra's blog

To find the blocking sessions in 10G “v$session.blocking_session” column is used to find the blocking session.

Oracle 11G made the life more easier , in 11G there is a view “v$session_blockers” by using which we can find the blocking sessions in the database.

SQL> select SID,WAIT_EVENT,WAIT_EVENT_TEXT,BLOCKER_SID from v$session_blockers;

       SID WAIT_EVENT WAIT_EVENT_TEXT                                                  BLOCKER_SID
———- ———- —————————————————————- ———–
        69        237 enq: TX – row lock contention                                             33