When Oracle updates or deletes a record, it is unable to operate or be locked for resolution __oracle

When a record is updated or deleted, it cannot be manipulated, or is locked, and sometimes, when we do update or delete on Oracle, there is no time to get the result of the operation,
has been in the process of being processed, it is time to consider whether Oracle itself has locked the record. 1: View whether the record is locked SELECT a.object_id, a.session_id, b.object_name from V$locked_object A, dba_objects b WHERE a.object_id = b. OBJECT_ID 2: View the locked record ID select object_name,machine,s.sid,s.serial# from v$locked_object l,dba_objects o, v$session s wher E l.object_id = o.object_id and l.session_id=s.sid 3: Delete or unlock the record alert system kill session ' sid,serial# ' (for example: Alert system Kill session ' 1,1212 ')