Oracle blocking

 today one of our interface queued up, I got the call and noticed the table the interface was inserting was locked .

I used following script to identify the blocker:

select a.sid, a.serial#, a.process

 from v$session a, v$locked_object b, dba_objects c

 where b.object_id = c.object_id

 and a.sid = b.session_id

 and OBJECT_NAME=upper('xxxxxtablexxxxname');

 then alter system kill session 'sid,servial#' immediate;

the blocker was one developer run a stored procedure locking that table, but not commit and left sql developer open.