SQL>     execute enqwaits
.
Waiter: SID=12 (ACTIVE), Logged on at 24-JUL 16:24
....... REQUESTED LOCK|MODE=TX (Transaction) | Exclusive (589859,15600)
....... AppsUser=SYSTEM
....... OS PID=25456
.... TXN ID=3.29.14643 (ACTIVE) started=07/24/07 16:24:12 undo=1b/2r
....... DML Lock: SYSTEM.TITI (TABLE) - LOCK HELD=Sub-Exclusive
....... DML Lock: SYSTEM.TOTO (TABLE) - LOCK HELD=Sub-Exclusive
.... SQL Statement currently executing:
....... delete from toto
==>BLOCKER: SID=11,9164 (INACTIVE), Logged on at 24-JUL 16:23
........... HELD LOCK|MODE=TX (Transaction) | Exclusive
........... AppsUser=SYSTEM
........... OS PID=25450
....... TXN ID=9.35.15600 (ACTIVE) started=07/24/07 16:23:59 undo=1b/2r
........... DML Lock: SYSTEM.TOTO (TABLE) - LOCK HELD=Sub-Exclusive
....... SQL currently executing (not necessarily the blocking SQL):
.
Waiter: SID=24 (ACTIVE), Logged on at 24-JUL 16:24
....... REQUESTED LOCK|MODE=TX (Transaction) | Exclusive (196637,14643)
....... AppsUser=SYSTEM
....... OS PID=25458
.... TXN ID=.. () started= undo=b/r
.
Waiter: SID=12 (ACTIVE), Logged on at 24-JUL 16:24
....... REQUESTED LOCK|MODE=TX (Transaction) | Exclusive (589859,15600)
....... AppsUser=SYSTEM
....... OS PID=25456
.... TXN ID=3.29.14643 (ACTIVE) started=07/24/07 16:24:12 undo=1b/2r
....... DML Lock: SYSTEM.TITI (TABLE) - LOCK HELD=Sub-Exclusive
....... DML Lock: SYSTEM.TOTO (TABLE) - LOCK HELD=Sub-Exclusive
.... SQL Statement currently executing:
....... delete from toto
==>BLOCKER: SID=11,9164 (INACTIVE), Logged on at 24-JUL 16:23
........... HELD LOCK|MODE=TX (Transaction) | Exclusive
........... AppsUser=SYSTEM
........... OS PID=25450
....... TXN ID=9.35.15600 (ACTIVE) started=07/24/07 16:23:59 undo=1b/2r
........... DML Lock: SYSTEM.TOTO (TABLE) - LOCK HELD=Sub-Exclusive
....... SQL currently executing (not necessarily the blocking SQL):
.
Waiter: SID=24 (ACTIVE), Logged on at 24-JUL 16:24
....... REQUESTED LOCK|MODE=TX (Transaction) | Exclusive (196637,14643)
....... AppsUser=SYSTEM
....... OS PID=25458
.... TXN ID=.. () started= undo=b/r
....... DML Lock: SYSTEM.TITI (TABLE) - LOCK HELD=Sub-Exclusive
.... SQL Statement currently executing:
....... delete from titi
==>BLOCKER: SID=12,16888 (ACTIVE), Logged on at 24-JUL 16:24
........... HELD LOCK|MODE=TX (Transaction) | Exclusive
........... AppsUser=SYSTEM
........... OS PID=25456
....... TXN ID=3.29.14643 (ACTIVE) started=07/24/07 16:24:12 undo=1b/2r
........... DML Lock: SYSTEM.TITI (TABLE) - LOCK HELD=Sub-Exclusive
........... DML Lock: SYSTEM.TOTO (TABLE) - LOCK HELD=Sub-Exclusive
....... SQL currently executing (not necessarily the blocking SQL):
........... delete from toto
Elapsed: 00:02:19.01