sys@TEST>l
1 select addr,sid,type,id1,id2,lmode,request,block from v$lock where type in('TX','TM')
2*sys@TEST>/
ADDR SID TY ID1 ID2 LMODE REQUEST BLOCK
-------- ---------- -- ---------- ---------- ---------- ---------- ----------
5B9E4430 12 TX 196609 286 6 0 0
5B9A8978 12 TM 6339 0 3 0 1
5B9A88F4 12 TM 6337 0 2 0 0
5B9E405C 17 TX 458760 483 6 0 0
5B9A8A80 17 TM 6339 0 3 5 0
5B9A89FC 17 TM 6337 0 3 0 0