strang table locking
Date: Sun, 28 Jan 2001 07:33:44 GMT
Message-ID: <950i0p$7tc$1_at_nnrp1.deja.com>
[Quoted] I have an app that open 2 database connections concurrently. It hangs couple times a week due to table lock. The following is a report shows what happen:
USERNAME SID SERIAL# TY HELD REQUEST
SQL
PROD_USER 13 124 TX Exclusive None UPDATE object set flag = 1 WHERE plan = 'A' AND Id = 3466629
PROD_USER 29 9034 TX None Share UPDATE object set flag = 1 WHERE plan = 'B' AND Id = 3466631;
The two sessions(SID 13,29) are updating different rows so I have no idea how this can generate locks. I do not set up any locking feature. I tried to disable all foreign keys but it didn't help. I also tried rebuild the corresponding tables and indexes(I suspect due to corrupted indexes) but still didn't help.
Please help!
Susan
Sent via Deja.com
http://www.deja.com/
Received on Sun Jan 28 2001 - 08:33:44 CET