Close the Oracle deadlock Process

The following articles mainly introduce the specific operation steps for shutting down the Oracle deadlock process. We first start from checking which actual process is locked. The following describes the specific content of the article, the following is an introduction to the specific content of the article. I hope you will gain some benefits after browsing.

1. Check which process is locked

Check the V $ DB_OBJECT_CACHE View:

 
 

  
  
SELECT * from v $ DB_OBJECT_CACHE where owner = 'user of the process' and clocks! = '0 ';
 
 

2. Check which SID is used to find the SESSION.

Check the V $ ACCESS View:

 
 

  
  
SELECT * from v $ access where owner = 'user of the process' and name = 'process NAME just found ';
 
 

3. Identify SID and SERIAL

Check the V $ SESSION View:

 
 

  
  
Select sid, SERIAL #, paddr from v $ session where sid = 'sid just found'
 
 

View V $ PROCESS:

 
 

  
  
Select spid from v $ process where addr = 'paddr just found ';
 
 

4. Kill processes

(1) first kill the Oracle deadlock process:

 
 

  
  
Alter system kill session 'sid, SERIAL #';
 
 

IXDBA. NET Community Forum

(2). Then kill the operating system process:

KILL-9 The SPID just found

Or use ORAKILL to locate the SID and SPID ).