Home » RDBMS Server » Server Administration » DeadLocks
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?
Previous Topic: metalink help
Next Topic: FATAL ERROR IN TWO-TASK SERVER: error = 12571
Goto Forum:
  


Current Time: Thu Dec 08 04:08:15 CST 2016

Total time taken to generate the page: 0.25229 seconds