Re: finding solution 4 this Special DeadLock
Date: Sun, 24 Feb 2008 22:26:49 -0800 (PST)
i searched but i didn't fount any useful topic or solution please tell me in application , our application developer used LOCK TABLE ... IN EXCLUSIVE MODE and ... straightly or it's result of compile my code ??
i use query ( SELECT * FROM ALL_SOURCE WHERE TEXT LIKE '%LOCK TABLE PER_ANALYSIS_CRITERIA IN EXCLUSIVE MODE%' ) but i didn't found any row !!!
wheras in my trace file this statement is Wait sql statement???? how can i found cause of this deadlock sql statement ??
Best Regards Received on Mon Feb 25 2008 - 00:26:49 CST