Unindexed FK Cause Deadlock or Only Share Lock? 2005-06-30 - By oracle-l-bounce@(protected)
That was one of the links in the original email. I see that it attempts
to explain the mechanics, and perhaps I am thick and don't understand,
but it seems to me it is just telling me why things will run "faster",
it doesn't explain the difference in why...
1) sometimes you get share locks
2) sometimes you get deadlocks
3) sometime a fk prevents #2 (I assume some sort of #1 still occurs).
Also the information seems a little old (2003) and the in the link to
Tom's stuff he kept seeming to reiterate a share lock when questioners
were driving him towards deadlock. Tom carries a lot of weight with me.
-- --Original Message-- --
From: Reidy, Ron [mailto:Ron.Reidy@(protected)]
Sent: Thursday, June 30, 2005 1:58 PM
To: Post, Ethan; Allen, Brandon; Oracle-L@(protected) Org (E-mail)
Subject: RE: Unindexed FK Cause Deadlock or Only Share Lock?
http://www.zanthan.com/itymbi/archives/001548.html
-- ---- ---- ----
Ron Reidy
Lead DBA
Array BioPharma, Inc.
--
http://www.freelists.org/webpage/oracle-l
|
|
