Oracle 查询表锁及处理

1.查询表锁情况

SELECT owner,object_name,session_id,locked_mode from(
select b.owner,b.object_name,a.session_id,a.locked_mode 
from v$locked_object a,dba_objects b 
where b.object_id = a.object_id
)
WHERE 1=1
--AND owner='EDALDR'--用户
AND object_name like'%CHAMBER%';--表名

2.查询SESSION ID 对应的 serial

SELECT sid, serial#, username, osuser FROM v$session
WHERE sid in(600); 

3.kill session（需要管理员权限）

alter system kill session'600,6122';