关联表:v$session,v$locked_object,dba_objects
select s.sid,s.serial#,s.username,s.machine,d.object_name
from v$session s,v$locked_object l,dba_objects d
where s.sid=l.session_id and l.object_id = d.object_id;
原文：http://www.cnblogs.com/-yhhtx/p/4444653.html