查询oracle数据库 锁表 sql

selectobject_name,machine,s.sid,s.serial#

fromv$locked_objectl,dba_objectso,v$sessions

wherel.object_id　=　o.object_id

andl.session_id=s.sid;

select*

fromv$locked_objectl,dba_objectso,v$sessions

wherel.object_id　=　o.object_id

andl.session_id=s.sid;