Oracle数据死锁
select s.username,s.sid,s.serial#,s.logon_time from v$locked_object a,v$session s where a.session_id=s.sid order by s.logon_time;
alter system kill session '19,27545';
select s.username,s.sid,s.serial#,s.logon_time from v$locked_object a,v$session s where a.session_id=s.sid order by s.logon_time;
alter system kill session '19,27545';