查看Oracle数据库锁表以及解锁

1、锁表查询的 sql 有以下的形式：

select count(*) from v$locked_object;

select * from v$locked_object;

2、查看哪个表被锁

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;

3、查看是哪个session引起的

select 
	b.username,
	b.sid,
	b.serial#,
	logon_time 
from v$locked_object a,v$session b 
where a.session_id = b.sid order by b.logon_time; 

4、杀掉对应进程

--执行命令（其中1025为sid,41为serial#）
alter system kill session'1025,41';