Oracle 死鎖了怎么辦？

大概是執(zhí)行了 update 語句沒有成功，查詢

select b.object_name obj_name,
       d.ctime time,
       to_char(d.lmode) l,
       to_char(d.request) r,
       a.os_user_name os_user,
       c.machine machine,
       c.program program,
       c.serial# s_serial,
       a.oracle_username ora_user,
       a.object_id obj_id,
       a.process pid,
       a.session_id s_id,
       p.spid
from v$locked_object a, all_objects b, v$session c, v$lock d,V$process p
where a.object_id=b.object_id
and c.Paddr = p.Addr
and a.session_id=c.sid
and a.session_id=d.sid
and d.type='TX'
order by d.ctime desc, p.spid

覺得應該是行死鎖了，參考

http://blog.51cto.com/badboy6...

里面說是要到服務(wù)器上去跑命令行

alter system kill session 'sid,serial#'

才能解鎖

數(shù)據(jù)庫是在服務(wù)器上的不能直接遠程，還有什么方法能解決Oracle死鎖的問題呢？

還是我本地注銷，或者明天再來看會不會就解了呢？（應該不太可能）