How to deal with Oracle deadlock sessions

Oracle deadlock session processing method when a deadlock occurs in Oracle, the Operation deadlock data will remain in the waiting state. The specific solution is as follows: Query all deadlocks: 1 SELECT * from v $ LOCK; query all sessions: 1 SELECT * from v $ SESSION; www.2cto.com query all deadlocked sessions: 1 select sn. SID, 2 SN. SERIAL #, 3 SN. USERNAME, 4 SN. MACHINE, 5 SN. TERMINAL, 6 SN. PROGRAM, 7 SN. TYPE8 from v $ SESSION SN9 where sn. sid in (select lk. sid from v $ lock lk); KILL a deadlock SESSION: alter system kill session 'sid, SERIAL # '; Author: Wu Zi