select l.*, o.owner object_owner, o.object_name
from sys.all_objects o, v$lock l
where o.owner = 'SCOTT' and o.object_name = 'EMP'
and l.id1 = o.object_id