ORACLE-013: kill deadlock process in oracle, oracle-013oracle

ORACLE-013: kill deadlock process in oracle, oracle-013oracle

In oracle, stored procedures or functions that frequently access packets may cause deadlocks. Scripts of deadlocked objects cannot be run, causing freezing or an exception: too many connections are opened.

In this case, you need to use the dba account to kill the deadlock object.

Use

Alter system kill the ID of the session deadlock object;

Run the following SQL statement to find the deadlock ID and splice the alter statement:

Select Distinct 'alter system kill session '| chr (39) | B. sid | ',' | B. serial # | chr (39) | ';' As kill object SQL statement, B. username, B. logon_timefrom v $ locked_object a, v $ session bwhere. session_id = B. sidorder by B. logon_time;

Then, execute the concatenated statement.