系统经常出现大量的锁问题讨论
***系统近期每天都会经常出现大量的锁，主要是在AP_INVOICES_H 表上，造成大量session阻塞，导致jdbc 连接池报警。
近期都通过kill session的方式释放holder session，解决问题，请***尽快联系开发同事，尽快查明原因解决。
另外，在问题解决之前，大家要关注一下该系统。 ***帮忙把锁的监控也增加到目前的数据库报警中。（目前active session高能说明该问题)
涉及的sql如下，（发现如下sql都在等待，或者holder) 请尽快查明原因。否则再次导致scs故障。
/* Formatted on 2011-2-24 18:03:45 (QP5 v5.115.810.9015) */
UPDATE AP_INVOICES_H
SET MATCH_INVOICE_NUM = :B8,
INVOICE_NUM = :B7,
INVOICE_AMT = :B6,
INVOICE_TAX_AMT = :B5,
INVOICE_DATE = TO_DATE (:B4, 'yyyy-mm-dd'),
INVOICE_TYPE = :B3,
INVOICE_STATUS = 21,
REMARK = :B2
WHERE INVOICE_ID = :B1
UPDATE AP_INVOICES_H
SET MATCH_INVOICE_NUM = :B8,
INVOICE_NUM = :B7,
INVOICE_AMT = :B6,
INVOICE_TAX_AMT = :B5,
INVOICE_DATE = TO_DATE (:B4, 'yyyy-mm-dd'),
INVOICE_TYPE = :B3,
INVOICE_STATUS = 21,
REMARK = :B2
WHERE INVOICE_ID = :B1
/* Formatted on 2011-2-25 19:36:06 (QP5 v5.115.810.9015) */
UPDATE AP_INVOICES_H
SET ATTRIBUTE1 = :B2
WHERE INVOICE_ID = :B1
DELETE AP_INVOICES_H
WHERE AP_INVOICES_H.INVOICE_ID=：B1
内存监控截图略(公司网络上载不了图片).
UPDATE AP_INVOICES_H
SET ATTRIBUTE1 = :B2
WHERE INVOICE_ID = :B1
DELETE AP_INVOICES_H
WHERE AP_INVOICES_H.INVOICE_ID=：B1
内存监控截图略(公司网络上载不了图片).
请各位看看,有什么建议,如何处理?