Resolving Lock Conflicts Using SQL

1) select sid, serial#, username from v$session where sid in
   (select blocking_session from v$session)

result
--------------------
sid  serial#
144  8982

2) alter system kill session '144,8982' immediate;




** deadlock

session1>
update employees
set salary = salary * 1.1
where employee_id = 1000;

session2>
update employees
set manager_id = 1342
where employee_id = 2000;

session1>
update employees
set salary = salary * 1.1
where employee_id = 2000;

session2>
update employees
set manager_id = 1342
where employee_id = 1000;