Re: finding solution 4 this Special DeadLock
Date: Fri, 22 Feb 2008 23:51:19 -0800 (PST)
Message-ID: <266aad51-c0df-4ae1-80ed-f59a106b2524@71g2000hse.googlegroups.com>
hi
i read what Jonathan said again carefully but i can't get any idea
from her notes.
for test i manually make 2 table as Master-Details
and lock details table in Row Share Mode
then with another session again lock details table in Exclusive mode
till now a block created ( RR mode block X request)
again as Jonathan said i lock manually with session that has SS lock
details table in SS Mode
but i see no block or lock !!!! (that means cause of waiting X lock on
details table my second Request for SS lock didn't created any new
block or lock in fact my block list and my lock list didn't
changed !!!!
also i checked ss request lock in table that has SS lock, but without
any problem new request lock on same table was created !!!
i dont know correctly what should i search in Application??
Received on Sat Feb 23 2008 - 01:51:19 CST