查看哪些对象被lock

Oracle 数据库无 SELECT /* 规则 */ s.username, DECODE (l.TYPE, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL ) lock_level, o.owner, o. object_name、o.object_type、s.SID、s.serial#、s.terminal、s.machine、s.program、s.osuser 来自 v$session s、v$

Oracle数据库

SELECT /*+ rule */
       s.username,
       DECODE (l.TYPE,
               'TM', 'TABLE LOCK',
               'TX', 'ROW LOCK',
               NULL
              ) lock_level, o.owner, o.object_name, o.object_type, s.SID,
       s.serial#, s.terminal, s.machine, s.program, s.osuser
  FROM v$session s, v$lock l, dba_objects o
 WHERE l.SID = s.SID AND l.id1 = o.object_id(+) AND s.username IS NOT NULL