数据库死锁-解锁

1.找出谁锁定了什么
Select v2.username, v2.sid, v2.serial#, v2.logon_time
From v$locked_object v1, v$session v2
Where v1.session_id = v2.sid
order by v2.logon_time;

2.结束掉这个session
alter system kill session 'sid,serial#';