How to delete the deadlock process in Oracle, and delete the lock process in oracle

How to delete the deadlock process in Oracle, and delete the lock process in oracle

This example describes how to delete a deadlock process in Oracle. Share it with you for your reference. The details are as follows:

Step 1: Use the following SQL statement to view the process list and identify the locked table
Copy codeThe Code is as follows: SELECT dob. OBJECT_NAME Table_Name, lo. SESSION_ID | ',' | vss. SERIAL # delete number,
Lo. locked_mode, lo. SESSION_ID, vss. SERIAL #, vss. action Action, vss. osuser OSUSER, vss. LOGON_TIME,
Vss. process AP_PID, VPS. SPID DB_PID, vss .*
From v $ locked_object lo, dba_objects dob, v $ session vss, V $ PROCESS VPS
Where lo. OBJECT_ID = dob. OBJECT_ID
And lo. SESSION_ID = vss. SID
And vss. paddr = VPS. addr
Order by 2, 3, DOB. object_name

Searching locked tables

Step 2: delete a process. If the result of the previous "delete number" is "286,218 4", run the following SQL
Copy codeThe Code is as follows: ALTER system kill session '2017 4'

It will not take effect immediately after deletion. It will take a while.

I hope this article will help you with Oracle programming.