Oracle数据库发生锁表怎么办？＜＜解除死锁笔记＞＞

Oracle数据库发生锁表怎么办？

查询被锁表及会话

select b.owner,b.object_name,a.session_id,a.locked_mode,c.username,c.sid,c.serial#,logon_time

from v$locked_object a,dba_objects b,v$session c

where b.object_id = a.object_id and a.session_id = c.sid;

解除死锁

ALTER SYSTEM KILL SESSION '6256,5677';--(SID,SERIAL#)