[Aplaws-devel] [aplaws - Developing on APLAWS+] RE: Performance

[Aplaws D. L. <apl...@li...>]

Read and respond to this message at: 
https://sourceforge.net/forum/message.php?msg_id=7553176
By: alan_permeance

We've fixed our deadlocking issues (thanks Tim Carpenter). 

Oracle issues a SHARE lock on child tables when updating parents when there
is no index on the FK column. If two transactions have a SHARE lock they will
deadlock when DML starts to happen.

Once we ensured that all Foreign keys had a single column index the dead locks
went away.
We haven't tested this on Postgres.

We have updated the oracle-se-create.sql and postgres-create.sql to ensure the
indexes are created during a load-bundle and we commit them soonish.

Reference:
http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10795/adfns_sq.htm#1024
837
http://www.oracle-base.com/articles/9i/SQLNewFeatures9i.php#ShareLocksOnUnindexedFKs

______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit: 
https://sourceforge.net/forum/unmonitor.php?forum_id=368401