select object_name,machine,s.sid,s.serial# 
from gv$locked_object I,dba_objects o,gv$session s 
where I.OBJECT_ID=o.OBJECT_ID and I.SESSION_ID=s.SID;