close

找指定的表格被哪些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=;
arrow
arrow
    全站熱搜

    keven 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄