Re: Powerbuilder and Oracle Locking--HELP!!!!
Date: 1995/04/06
Message-ID: <3m1507$a05_at_blackice.winternet.com>#1/1
You might want to check your referential integrity constraints. The rule of thumb is to create index for your constraint when it's referencing other tables. Especially with parent and child relationship. Make sure you have index for parent constraints on child table. HTH.
Carl Hoang choang_at_winternet.com
vv_at_mbunix.mitre.org (Vincent A Ventrone) wrote:
>We are using Oracle 7.0.16 and Powerbuilder and getting shared table locks
>which keep other users from updating and occasionally lead to deadlocks.
>Has anyone had a similar experience? The developers claim that they
>are not doing this--and a Powerbuilder "expert" says it's not Powerbuilder.
>Thanks.
>--
> Vince Ventrone
> The MITRE Corporation "...In my opinion, there's nothing
> Bedford, MA 01730 in this world beats a '52 Vincent
> vav_at_mitre.org and a redheaded girl." -- Richard Thompson
Received on Thu Apr 06 1995 - 00:00:00 CEST