oracle怎么查看用户锁了哪张表

关联表: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;