Re: Powerbuilder and Oracle Locking--HELP!!!!
Date: 1995/04/06
Message-ID: <3m0q01$c3i_at_world.net>#1/1
In article <3luhjl$nbk_at_linus.mitre.org>, vv_at_mbunix.mitre.org says...
>
>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.
>
>Any clues in netland???
>
This can happen in ORACLE if you are using foreign keys without
indexes over them. If table A has a primary key and then table B
references the primary key with no index, then deleting a row in table
A will result in a share table lock on table B.
The solution is to always create an index over any foreign key.
Regards,
Michael Harvey (mgh_at_world.net)