SELECT o.object_name, o.object_type, l.session_id, l.locked_mode
FROM v$locked_object l
JOIN dba_objects o ON l.object_id = o.object_id;