找指定的表格被哪些Session鎖住,type='TM'時,ID1等於OBJECT ID
select obj.object_name,vs.sid,vs.serial#,vp.spid,vs.action,vs.sql_address,vl.ctime,vl.block
from dba_objects obj,v$lock vl,v$session vs,v$process vp
where obj.object_id=vl.id1
and vl.sid=vs.sid
and vp.addr=vs.paddr
and vl.type='TM'
and obj.object_name=