Workflow Siebel Operation is Slow on First Execution during Insert record into Activity Table
(Doc ID 484484.1)
Last updated on FEBRUARY 04, 2022
Applies to:
Siebel Workflow - Version 7.7.2 SIA [18325] and laterOracle 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
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 more than 20 seconds to perform this step.
Subsequently this step only takes less than 2 seconds (within the same user session). If user logs back in again and reruns the workflow, it takes more than 20 seconds again.
If users create the same record through the UI, then there is no time delay.
This happens both on dedicated and web client.
An 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?
Changes
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 |
| Changes |
| Cause |
| Solution |