系統經常出現大量的鎖問題討論
***系統近期每天都會經常出現大量的鎖，主要是在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
內存監控截圖略(公司網絡上載不了圖片).
請各位看看,有什么建議,如何處理?
本文由用戶 wf1006 自行上傳分享，僅供網友學習交流。所有權歸原作者，若您的權利被侵害，請聯系管理員。
轉載本站原創文章，請注明出處，并保留原始鏈接、圖片水印。
本站是一個以用戶分享為主的開源技術平臺，歡迎各類分享！
wf1006 
ls889 
ck2265395