RE: Unindexed FK Cause Deadlock or Only Share Lock?

From: <oracle-l-bounce_at_freelists.org>
Date: Thu, 30 Jun 2005 14:07:45 -0500
Message-ID: <1F989681BA05FA4CAD9FA849ED8520576DDFCB@pscdalpexch01.perotsystems.net>

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_at_arraybiopharma.com] Sent: Thursday, June 30, 2005 1:58 PM
To: Post, Ethan; Allen, Brandon; Oracle-L_at_Freelists. 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 Received on Thu Jun 30 2005 - 15:13:24 CDT