Statement used by Oracle to query deadlock information: selecta. owner, a. object_name, B. xidusn, B. xidslot, B. xi
Statement used by Oracle to query deadlock information: select a. owner, a. object_name, B. xidusn, B. xidslot, B. xi
Statement for querying deadlock information in Oracle:
Step 1: Check whether a deadlock exists. If a deadlock exists, it indicates a deadlock:
Step 2: Find the exact information of the deadlock session [sid is the session_id of the previous statement]
Step 3: delete the deadlock. The first parameter is sid and the second parameter is serial #]
If the problem persists ,,
Select pro. spid from v $ session ses, v $ process pro where ses. sid = XX and ses. paddr = pro. addr;
The sid is replaced by the sid of the deadlock.
Exit
Ps-ef | grep spid
Spid is the process Number of the process and kill the Oracle process.