oracle查看锁信息可以通过v$lock视图
SCOTT@orcl>select sid,type,id1,id2,lmode,block,request from v$lock where sid in(133,199) order by sid;
SID TY ID1 ID2 LMODE BLOCK REQUEST
---------- -- ---------- ---------- ---------- ---------- ----------
133 AE 100 0 4 0 0
133 TM 75366 0 3 0 0
133 TO 65921 1 3 0 0
133 TX 655363 1185 6 1 0
199 TM 75366 0 3 0 0
199 AE 100 0 4 0 0
199 TX 655363 1185 0 0 6