Solution to update and delete Oracle records locked by another user

Solution to Oracle "record locked by another user" failure to update and delete: 1. view the database lock and the source and type of the diagnostic lock: select object_id, session_id, locked_mode from v $ locked_object; or run 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 SELECT lpad ('', decode (l. xidusn, 0, 3, 0) | l. oracle_username User_name, o. owner, o. object_name, o. object_type, s. sid, s. serial # FROM v $ locked_object l, dba_objects o, v $ session s WHERE l. object_id = o. object_id AND l. session_id = s. sid order by o. object_id, xidusn DESC 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 order by t2.logon _ time; 3. kill the session alter system kill session 'sid. serial # uses the records found in step 2, corresponding to this statement to delete