Pl/SQL deadlock: record is locked by another user

Pl/SQL deadlock: record is locked by another user due to a problem, I found a solution in a blog. After a try, I found the solution feasible! Www.2cto.com is afraid of poor memory! Also as your own search direction 1. PL/SQL query locks: select t2.username, t2.sid, t2.serial #, t2.logon _ timefrom v $ locked_object t1, v $ session t2where t1.session _ id = t2.sid order t2.logon _ time; or log in with the Administrator account in pl/SQL developer. Click session in the menu bar to view the login information of all users.
Www.2cto.com 2. Check the lock and find sid, serial #. kill all the locks. alter system kill session 'sid, serial #'