| DeadLocks [message #214541] |
Tue, 16 January 2007 23:18 |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
I had checked alertlog file and found the following
Tue Jan 16 11:37:57 2007
ORA-000060: Deadlock detected. More info in file E:\oracle\admin\wizerp\udump\ORA02996.TRC.
and when i checked that ORA02996.TRC file
DEADLOCK DETECTED
Current SQL statement for this session:
SELECT 1 FROM journal_mt WHERE journal_id=
( SELECT NVL(MAX(journal_id),1 - 1) FROM journal_mt WHERE journal_id BETWEEN 1 AND 99999999) FOR UPDATE
i also had found some other statements in that particular ORA02996.TRC file
But i suspect that the above mentioned statement is the major source of deadlock
My question is ,should i look in-depth the above mentioned query
or i have to look the other statements in this trace file to resolve the deadlocks?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
