Workflow background process spends a lot of time on a few statements
Hi,
After we applied ATG RUP7 a couple of weeks ago, we started seeing that WF Background process started taking a lot longer than before. We traced the session and found out that most of the time is being spent on the following statements:
1.
begin JTF_BRM_PVT.PROCESS_RULES (:v1, :v2, :v3, :v4, :v5); end;
2.
SELECT object_type, object_id
FROM
JTF_BRM_000010000_V
3.
SELECT object_type, object_id
FROM
JTF_BRM_000010024_V
4.
SELECT RESOURCE_NAME
from
JTF_RS_EMP_DTLS_VL where RESOURCE_ID = :object_id and rownum = 1
Somehow it seems to be related to BRM (Business Rule Monitor), but we can't figure out what the problem is.
After we applied ATG RUP7 a couple of weeks ago, we started seeing that WF Background process started taking a lot longer than before. We traced the session and found out that most of the time is being spent on the following statements:
1.
begin JTF_BRM_PVT.PROCESS_RULES (:v1, :v2, :v3, :v4, :v5); end;
2.
SELECT object_type, object_id
FROM
JTF_BRM_000010000_V
3.
SELECT object_type, object_id
FROM
JTF_BRM_000010024_V
4.
SELECT RESOURCE_NAME
from
JTF_RS_EMP_DTLS_VL where RESOURCE_ID = :object_id and rownum = 1
Somehow it seems to be related to BRM (Business Rule Monitor), but we can't figure out what the problem is.
0