查看oracle数据库 锁表和 解锁

 

• --查询谁锁定，谁等待
• SELECT /*+ rule */  
  lpad(' ', decode(l.xidusn, 0, 3, 0)) || l.oracle_username User_name,  
  o.owner,  
  o.object_name,  
  o.object_type,  
  s.sid,  
  s.serial#  
    FROM v$locked_object l, dba_objects o, v$session s  
  WHERE l.object_id = o.object_id  
     AND l.session_id = s.sid  
  ORDER BY o.object_id, xidusn DESC
• 
  

• --释放session Sql 语法:
• --alter system kill session 'sid, serial#'
• --例子：
• alter system kill session'379, 21132';

  SELECT s.sid, s.serial#, s.username, s.schemaname, s.osuser, s.process, s.machine,
         s.terminal, s.logon_time, l.type
      FROM v$session s, v$lock l
     WHERE s.sid = l.sid
       AND s.username IS NOT NULL
  ORDER BY sid;