Originally posted by ggnanaraj
The following simulates your environment:

SEssion 1:
insert into temp values('1');
commit;

Session 2:
insert into temp values('2');

SEssion 1:
delete from temp;
1 row deleted.

Session 2:
delete from temp;
(hangs)

SEssion 1:
commit;

Session 2:
(comes alive)

HTH.
If I dont give a commit at the end of the above quote for session 1. It waits/hangs indefinitely in Session 2. So this is not a deadlock (which is detected by the database) but a lock.

HTH.