找指定的表格被哪些Session鎖住


找指定的表格被哪些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=;