Steps for shutting down the Oracle deadlock Process

Steps for effectively disabling the Oracle deadlock process: 1. Check which process is locked. V $ DB_OBJECT_CACHE view: SELECT * FROMV $ DB_OBJECT_CACHEWHEREOWNER process owner ANDCLOCKS! 0; 2. Check which SID is used. The SID can be used to know which SESSION to query V $ ACCESS view: SELECT * FROMV $ ACCESSW

Steps for effectively disabling the Oracle deadlock process: 1. Check which process is locked 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. You can use the SID to know which SESSION to query. V $ ACCESS view: SELECT * from v $ ACCESS W

Steps for effectively disabling the Oracle deadlock process:

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;

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 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 (the SID and SPID just found ).

,