A deadlock resolution appears on PL/SQL

A deadlock occurs when the data table is manipulated in PL/SQL and is unresponsive for a long time, and when editing data in a table, there is a "record is locked by another user".

Below, a brief description of the solution:

Step1.pl/sql View Lock:

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 T2.logon_time];

Step2. After viewing the lock, locate the sid,serial# and kill all the locks:

alter system kill session ' Sid, Serial# ';

Recommendation: Find the corresponding SID and serial, delete it individually.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

A deadlock resolution appears on PL/SQL