(1)锁表查询的代码形式如下:
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_is = b.sid orader by b.logon_time;
(4)杀掉对应对应缩表进程
执行命令:alter system kill session '1025,41';(注:1025为sid,41为serial#