RE: Unindexed FK Cause Deadlock or Only Share Lock?
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: "Post, Ethan" <Ethan.Post@xxxxxx>, "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Jun 2005 13:10:51 -0600
Sorry, I missed the original link.
The page is old, but the information is as old as v6 (maybe earlier).
I cannot explain why there is a discrepancy with the types of locks seen, but
for all of the 3rd party apps we run (Khameleon is one of them), the very first
thing I do when we get any type of patch, etc. from the vendor is to test that
all FKs have an associated index. This is missed so often that testing it is
routine here.
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Post, Ethan [mailto:Ethan.Post@xxxxxx]
Sent: Thursday, June 30, 2005 1:08 PM
To: Reidy, Ron; Allen, Brandon; Oracle-L@Freelists. Org (E-mail)
Subject: RE: Unindexed FK Cause Deadlock or Only Share Lock?
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@xxxxxxxxxxxxxxxxxx]
Sent: Thursday, June 30, 2005 1:58 PM
To: Post, Ethan; Allen, Brandon; Oracle-L@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.
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
