oracle数据库死锁临时解决办法

以sys用户登录数据库，执行
select sess.sid,
    sess.serial#,
    sess.LOGON_TIME,
    lo.oracle_username,
    lo.os_user_name,
    ao.object_name,
    lo.locked_mode
    from gv$locked_object lo,
    dba_objects ao,
    gv$session sess
where ao.object_id = lo.object_id and lo.session_id = sess.sid AND SESS.STATUS='INACTIVE'
order by logon_time asc;
可以查到出现死锁的sid和serial#
结束死锁的进程
alter system kill session 'sid,serial'




select a.SPID,b.SERIAL#,b.USERNAME  from v$process a,v$session b
where a.ADDR=b.PADDR and b.STATUS='KILLED'