怎么查找某张表被锁了？

tangxh

如题：怎么查找某张表被锁了？

pearaep

query v$locked_object

tangxh

col owner for a12
col object_name for a16

select b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b
where b.object_id=l.object_id

liuhg888

用select * from locked_object 和
select b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b
where b.object_id=l.object_id
查询，怎么第二个查出来的数量多呢，怎么区分那些是锁了那些是用户使用时的临时锁

zflying2000

直接copy给你看看吧！
--查看系统锁
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.STATUS,
      s.terminal,
      s.machine,
      s.program,
      s.osuser,
      s.LOGON_TIME
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
and s.status ='ACTIVE'
解锁及Kill Session:
使用下面的语法查出锁并杀掉Session。
SELECT A.SID,A.SERIAL#,A.USERNAME,B.TYPE FROM V$SESSION A,V$LOCK B WHERE A.SID=B.SID;
ALTER SYSTEM KILL SESSION 'SID,SERIAL#';