SELECT distinct (gvh.SID) sessid, gvh.inst_id, do.object_name, gvs.osuser, gvs.username, gvs.machine FROM gv$lock gvh, gv$lock gvw, gv$session gvs, dba_objects do, gv$locked_object vlo WHERE (gvh.id1, gvh.id2) IN (SELECT id1, id2 FROM gv$lock WHERE request = 0 INTERSECT SELECT id1, id2 FROM gv$lock WHERE lmode = 0) AND gvh.id1 = gvw.id1 AND gvh.id2 = gvw.id2 AND gvh.request = 0 AND gvw.lmode = 0 AND gvh.SID = gvs.final_blocking_session AND gvh.sid = vlo.session_id AND vlo.object_id = do.object_id AND gvh.inst_id = gvs.inst_id;