Oracle锁表

---

1 查询锁

SELECT s.sid, s.serial#, s.process, l.oracle_username, l.os_user_name, o.object_name, l.locked_mode
  FROM v$locked_object l, dba_objects o, v$session s
 WHERE o.object_id = l.object_id
   AND l.session_id = s.sid;

查询结果

2 释放锁

alter system kill session '1806,8991';