Identify Blocked SQL Processes Quickly: Figure 3 Run the dba_BlockTracer Stored Procedure.
This SQL code runs the dba_BlockTracer stored procedure. The output shows two grids; the first shows that the root-blocking spid is 86, and the second shows two blocked spids, 122 and 104. Both spid 104 and 122 are trying to select records from the tblCountry table.