Two tips for resolving Oracle database table deadlock

The first method: Log in with the system account like Sys as SYSDBA 1, view the database lock, diagnose the source and type of the lock: select Object_id,session_id,locked_mode from V$locked_object; or use the following command: Select B.owner,b.object_name,l.session_id,l.locked_mode from V$locked_object l, dba_objects b where b.object_ ID=L.OBJECT_ID 2, find the database serial# for killing: Select T2.username,t2.sid,t2.serial#,t2.logon_time from V$locked_object t1,v$ Session T2 where T1.session_id=t2.sid the order by T2.logon_time; 3, kill the session alter system kill sessions ' sid,serial# ' second method: Wait slowly, it is said that Oracle will also kill the process