Re: finding solution 4 this Special DeadLock
From: <meysam.khayatan_at_gmail.com>
Date: Sun, 24 Feb 2008 22:26:49 -0800 (PST)
Message-ID: <c5f4f965-c2ca-440c-acdb-32fc142a4eb3@p73g2000hsd.googlegroups.com>
Date: Sun, 24 Feb 2008 22:26:49 -0800 (PST)
Message-ID: <c5f4f965-c2ca-440c-acdb-32fc142a4eb3@p73g2000hsd.googlegroups.com>
yes
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