Workflow Siebel operation is slow on first execution during inserting record in activity table (Doc ID 484484.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Workflow - Version 7.7.2 SIA [18325] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.7.2 [18325] Pub Sect
Database: Oracle 9.2.0.2
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9

Checked for relevance on 05-Mar-2012
This document was previously published as Siebel SR 38-1768658805.


Symptoms

We have a workflow which inserts a record into a custom BC based on activity table using a Siebel Process Step.

First time the workflow is run for a user session it takes > 20 seconds to perform this step

Subsequently this step only takes < 2 seconds (when I am within the same user session) if I log back in again, rerun the workflow it's >20 seconds again.

If I create the same record through the UI there is no time delay.

This happens both on dedicated and web client.

I have attached a object manager log file, which shows some time delays at the time of the insert under "buffer wraps" which seems to be the cause of the time delay.

What are buffer wraps and what is causing this delay?

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