Oracle 如何查看被锁的对象

最新推荐文章于 2024-10-12 22:35:37 发布

weixin_30618985

最新推荐文章于 2024-10-12 22:35:37 发布

阅读量62

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/doonewei/archive/2012/04/17/2454237.html

版权

记住这句查询即可:

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);