Performance Degradation when the Workflow Background Process is Running

(Doc ID 743338.1)

Last updated on OCTOBER 04, 2016

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.
FNDWFBG - Workflow Background Process


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

--------------------------------------------------------------------------------
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms