Please Help: table locking

From: <susana73_at_hotmail.com>
Date: Tue, 12 Dec 2000 00:40:17 GMT
Message-ID: <913s5g$9dm$1_at_nnrp1.deja.com>

[Quoted] [Quoted] I have an app that open 2 database connections concurrently. It hangs [Quoted] [Quoted] couple times a week due to table lock. The following is a report shows what happen:

USERNAME SID SERIAL# TY HELD REQUEST

---

SQL

---

[Quoted] [Quoted] PROD_USER 13 124 TX Exclusive None [Quoted] [Quoted] UPDATE object set flag = 1 WHERE plan = 'A' AND Id = 3466629

[Quoted] 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 [Quoted] idea how this can generate locks. Session 13 is held as EXCLUSIVE and [Quoted] Session 29 are requesting as SHARE. What does that mean and would this [Quoted] be a hint to solve this problem?

[Quoted] [Quoted] I do not specify any locking feature explicitly in my application at all.

[Quoted] Please Help!! Thanks.

Susan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 12 2000 - 01:40:17 CET