ORACLE查锁语句

SELECT substr(v$lock.sid,1,4) "SID",
       substr(username,1,12) "UserName",
       substr(object_name,1,25) "ObjectName",
       v$lock.type "LockType",
       decode(rtrim(substr(lmode,1,4)),
       ‘2‘,‘Row-S (SS)‘,‘3‘,‘Row-X (SX)‘,
       ‘4‘,‘Share‘,     ‘5‘,‘S/Row-X (SSX)‘,
       ‘6‘,‘Exclusive‘, ‘Other‘ ) "LockMode",
       substr(v$session.program,1,25) "ProgramName"
FROM V$LOCK,SYS.DBA_OBJECTS,V$SESSION
WHERE (OBJECT_ID = v$lock.id1
      AND v$lock.sid = v$session.sid
      AND username IS NOT NULL
      AND username NOT IN (‘SYS‘,‘SYSTEM‘)
      AND SERIAL# != 1);

select a.sid, a.SERIAL#, b.spid, a.status, a.PROGRAM
from v$session a, V$PROCESS b
where a.paddr=b.ADDR
order by a.sid;

alter system kill session ‘200,68‘ immediate;

ORACLE查锁语句,布布扣,bubuko.com

ORACLE查锁语句

上一篇:Oracle小总结


下一篇:SQL -主键&外键