查询锁表的信息

SELECT *
  FROM V$LOCKED_OBJECT A, DBA_OBJECTS B
 WHERE A.OBJECT_ID = B.OBJECT_ID
   AND B.OBJECT_NAME = 'FND_USER_T'