Oracle解决死锁问题

--查找死锁会话id

selectsession_idfromv$locked_object;

--根据会话id查找死锁对象

selectsid,serial#,username,osuserfromv$sessionwheresid=47

--清楚死锁

altersystemkillsession'47,44649';