oracle锁对象查询

select o.OBJECT_NAME, l.SESSION_ID, l.ORACLE_USERNAME, l.OS_USER_NAME, l.PROCESS
  from V$LOCKED_OBJECT l, USER_OBJECTS o
where o.OBJECT_ID = l.OBJECT_ID;