Detecting Deadlock Source Part 2

Posted by oraclue on April 23, 2009 · 3 Comments 

This is very simple  deadlock case.Instad of event 10046 ( that I have used in previous blog ) to identify initial TX locks this time I  have used flashback version query and flashback transaction query . So here is demo: First craete table and populate some rows: create table t(a int primary key); insert into … Read more

Filed under Troubleshooting

Detecting Deadlock Source Part 1

Posted by oraclue on April 20, 2009 · 8 Comments 

In the case of deadlock oracle will raise ORA-60 error.Trace file is writen by the Global Enqueue Service Daemon (LMD) background process. Trace file will record sql involved but NOT the SQL  that initialy took the locks.It will record last entries. So how to resolve issue and get all data involved with deadlocks? Before I … Read more

Filed under Internals