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;