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 ).
,