Performance Degradation when the Workflow Background Process is Running
(Doc ID 743338.1)
Last updated on APRIL 11, 2024
Applies to:
Oracle Workflow - Version 11.5.10.0 to 12.2 [Release 11.5.10 to 12.2]Information in this document applies to any platform.
Symptoms
When the Workflow Background Process concurrent program is running, you notice a degradation of e-business suite performance. In the meantime, the database diagnostic script STATSPACK reports a very high number of Buffer Gets done by FNDWFBG module.
The STATSPACK output shows FNDWFBG module as the top performer of Buffer Gets:
----------------------------------------------------------------
SQL ordered by Gets for DB:
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
35,914,812 22 1,632,491.5 99.3 62.32 60.92 2076298416
Module: FNDWFBG
BEGIN WF_ENGINE.BACKGROUNDCONCURRENT( :errbuf, :rc,:A0,:A1,:A2,:
A3,:A4,:A5); END;
35,838,763 22 1,629,034.7 99.1 61.74 60.34 2254475455
Module: FNDWFBG
SELECT /*+ ORDERED USE_NL (WIASP WI WPAP WAP) INDEX
(WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */ WIASP.ROWID ROW_ID FROM
WF_ITEM_ACTIVITY_STATUSES WIASP, WF_ITEMS WI, WF_PROCESS_ACTIVIT
IES WPAP, WF_ACTIVITIES WAP WHERE WIASP.ITEM_TYPE = :B2 AND WIAS
P.PROCESS_ACTIVITY = WPAP.INSTANCE_ID AND WPAP.ACTIVITY_ITEM_TYP
--------------------------------------------------------------------------------
SQL ordered by Gets for DB:
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
35,914,812 22 1,632,491.5 99.3 62.32 60.92 2076298416
Module: FNDWFBG
BEGIN WF_ENGINE.BACKGROUNDCONCURRENT( :errbuf, :rc,:A0,:A1,:A2,:
A3,:A4,:A5); END;
35,838,763 22 1,629,034.7 99.1 61.74 60.34 2254475455
Module: FNDWFBG
SELECT /*+ ORDERED USE_NL (WIASP WI WPAP WAP) INDEX
(WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */ WIASP.ROWID ROW_ID FROM
WF_ITEM_ACTIVITY_STATUSES WIASP, WF_ITEMS WI, WF_PROCESS_ACTIVIT
IES WPAP, WF_ACTIVITIES WAP WHERE WIASP.ITEM_TYPE = :B2 AND WIAS
P.PROCESS_ACTIVITY = WPAP.INSTANCE_ID AND WPAP.ACTIVITY_ITEM_TYP
--------------------------------------------------------------------------------
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| Workflow Information Center, Diagnostics, & Community |
| References |