我查了一下sql发现一条语句最消耗资源:
UPDATE TB_LVY_DECLAREDETAILDATA A
SET A.RECEIPTFLAG = :B4
WHERE A.DECLARECANCELDATE >= :B3
AND A.DECLARECANCELDATE < :B2
AND A.RECEIPTFLAG IS NULL
AND A.DECLAREDATAID IN (SELECT B.DECLAREDATAID
FROM TB_LVY_DECLAREDATA B
WHERE B.TAXOFFICIALCODE = :B5
AND B.ORGDEPTCODE = :B1)
AND A.LEVYCODE = :B1