Re: deadlocks on 7.1.3.2

From: Sree Ghantasala <sree_at_bellsouth.net>
Date: Sat, 11 Apr 1998 23:34:08 GMT
Message-ID: <Q5TX.1806$Be.2388383@news1.atl.bellsouth.net>

May be you have referential integrity constraints defined on tables If you dont index the columns used in the ref integrity, oracle will try to lock the whole table in version 7.1 This is fixed partly in 7.2 + onwards.
Index all columns used in ref constraints in the child table .

This should solve your problem
Sree

Vincent Matlock wrote in message <6gitou$non_at_bgtnsc02.worldnet.att.net>...
>Hi everyone,
> I hope someone can help us...We have a deadlock problem on our server
>system. One table is being locked and not released, but we can't find out
Received on Sat Apr 11 1998 - 18:34:08 CDT