Daily Archives: 2011-10-30

Oracle中查看锁表情况的Sql语句

2011-10-30 by Jinyang | No Comments | Filed in Oracle

SELECT S.SID SESSION_ID, S.USERNAME, DECODE(LMODE,0,’None’,1,’Null’,2,’Row-S (SS)’, 3,’Row-X (SX)’,4,’Share’,5,’S/Row-X (SSX)’,6,’Exclusive’,TO_CHAR(LMODE)) MODE_HELD, DECODE(REQUEST,0,’None’,1,’Null’,2,’Row-S (SS)’,3,’Row-X (SX)’,4,’Share’,5,’S/Row-X (SSX)’,6, ‘Exclusive’,TO_CHAR(REQUEST)) MODE_REQUESTED, O.OWNER||’.’||O.OBJECT_NAME||'(‘||O.OBJECT_TYPE||’)’, S.TYPE LOCK_TYPE, L.ID1 LOCK_ID1, L.ID2 LOCK_ID2 FROM  V$LOCK L, SYS.DBA_OBJECTS O, V$SESSION S WHERE  L.SID  =  S.SID  AND   L.ID1  =  O. OBJECT_ID; SELECT S.SID SESSION_ID, S.USERNAME, DECODE(LMODE,0,’None’,1,’Null’,2,’Row-S (SS)’,  3,’Row-X (SX)’,4,’Share’,5,’S/Row-X (SSX)’,6,’Exclusive’,TO_CHAR(LMODE)) MODE_HELD,   DECODE(REQUEST,0,’None’,1,’Null’,2,’Row-S (SS)’,3,’Row-X (SX)’,4,’Share’,5,’S/Row-X (SSX)’,6, […]

返回顶部