查看哪台机器锁了表

SELECT S.MACHINE,
       L.ORACLE_USERNAME,
       L.OS_USER_NAME,
       O.OBJECT_NAME,
       S.USERNAME
  FROM V$LOCKED_OBJECT L, DBA_OBJECTS O, V$SESSION S
WHERE L.OBJECT_ID = O.OBJECT_ID
   AND S.SID = L.SESSION_ID