There are many ways to find locking /blocking sessions in Oracle, this is what I normally use. SELECT a.sid Blocker_SID, sb.username || '